HRS_ERP_APLC_LV

(SQL View)
 Index Back

My Applications

Applicant's Applications on Home page

SELECT A.HRS_PERSON_ID , D.LANGUAGE_CD , F.NAME_DISPLAY , D.DESCR , D.DESCRSHORT FROM PS_HRS_RCMNT_I A , PS_HRS_JO_I C , PS_HRS_STS_REC_LVW D , PS_HRS_APP_PROFILE E , PS_HRS_APP_NAME_LN F WHERE A.HRS_JOB_OPENING_ID=C.HRS_JOB_OPENING_ID AND E.HRS_PERSON_ID = F.HRS_PERSON_ID AND A.STATUS_CODE=D.STATUS_CODE AND A.HRS_PERSON_ID= E.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = E.HRS_PROFILE_SEQ AND F.LANGUAGE_CD = D.LANGUAGE_CD UNION SELECT A.HRS_PERSON_ID , D.LANGUAGE_CD , F.NAME_DISPLAY , D.DESCR , D.DESCRSHORT FROM PS_HRS_RCMNT_I A , PS_HRS_JO_I C , PS_HRS_STS_REC_LVW D , PS_HRS_APP_PROFILE E , PS_HRS_APP_NAME_I F WHERE A.HRS_JOB_OPENING_ID=C.HRS_JOB_OPENING_ID AND E.HRS_PERSON_ID = F.HRS_PERSON_ID AND A.STATUS_CODE=D.STATUS_CODE AND A.HRS_PERSON_ID= E.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = E.HRS_PROFILE_SEQ AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_APP_NAME_LN FL WHERE FL.HRS_PERSON_ID = F.HRS_PERSON_ID AND FL.LANGUAGE_CD = D.LANGUAGE_CD) UNION SELECT A.HRS_PERSON_ID , F.LANGUAGE_CD , F.NAME_DISPLAY , D.DESCR , D.DESCRSHORT FROM PS_HRS_RCMNT_I A , PS_HRS_JO_I C , PS_HRS_STS_REC_I D , PS_HRS_APP_PROFILE E , PS_HRS_APP_NAME_LN F WHERE A.HRS_JOB_OPENING_ID=C.HRS_JOB_OPENING_ID AND E.HRS_PERSON_ID = F.HRS_PERSON_ID AND A.STATUS_CODE=D.STATUS_CODE AND A.HRS_PERSON_ID= E.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = E.HRS_PROFILE_SEQ AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_STS_REC_LVW DL WHERE DL.STATUS_CODE=D.STATUS_CODE AND DL.LANGUAGE_CD = F.LANGUAGE_CD)

  • Related Language Record for HRS_ERP_APLC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description