eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_HRHD_RIR_WF dependencies on PER_PHONES

Line 1106: p_phone_id per_phones.phone_id%type;

1102: p_eff_date VARCHAR2(100);
1103: p_date date;
1104: myparameters wf_parameter_list_t;
1105:
1106: p_phone_id per_phones.phone_id%type;
1107: p_phn_date_from per_phones.date_from%type;
1108:
1109: cursor csr_person_id(p_phone_id varchar2,p_eff_date date)
1110: is select parent_id from per_phones

Line 1107: p_phn_date_from per_phones.date_from%type;

1103: p_date date;
1104: myparameters wf_parameter_list_t;
1105:
1106: p_phone_id per_phones.phone_id%type;
1107: p_phn_date_from per_phones.date_from%type;
1108:
1109: cursor csr_person_id(p_phone_id varchar2,p_eff_date date)
1110: is select parent_id from per_phones
1111: where phone_id = p_phone_id

Line 1110: is select parent_id from per_phones

1106: p_phone_id per_phones.phone_id%type;
1107: p_phn_date_from per_phones.date_from%type;
1108:
1109: cursor csr_person_id(p_phone_id varchar2,p_eff_date date)
1110: is select parent_id from per_phones
1111: where phone_id = p_phone_id
1112: and PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1113: and p_eff_date between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1114:

Line 1820: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn

1816: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1817: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1818: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1819:
1820: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn
1821: where ppf.person_id = :1
1822: and ppf.person_id = ppn.PARENT_ID
1823: and ppn.phone_id = :5
1824: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''

Line 3009: p_phone_id per_phones.phone_id%type;

3005: p_date date;
3006: p_event_data clob;
3007: p_person_id per_all_people_f.person_id%type;
3008:
3009: p_phone_id per_phones.phone_id%type;
3010: p_phn_date_from per_phones.date_from%type;
3011: p_phn_date_to per_phones.date_to%type;
3012: p_phone_type per_phones.phone_type%type;
3013: p_phone_number per_phones.phone_number%type;

Line 3010: p_phn_date_from per_phones.date_from%type;

3006: p_event_data clob;
3007: p_person_id per_all_people_f.person_id%type;
3008:
3009: p_phone_id per_phones.phone_id%type;
3010: p_phn_date_from per_phones.date_from%type;
3011: p_phn_date_to per_phones.date_to%type;
3012: p_phone_type per_phones.phone_type%type;
3013: p_phone_number per_phones.phone_number%type;
3014:

Line 3011: p_phn_date_to per_phones.date_to%type;

3007: p_person_id per_all_people_f.person_id%type;
3008:
3009: p_phone_id per_phones.phone_id%type;
3010: p_phn_date_from per_phones.date_from%type;
3011: p_phn_date_to per_phones.date_to%type;
3012: p_phone_type per_phones.phone_type%type;
3013: p_phone_number per_phones.phone_number%type;
3014:
3015: p_phn_date_from_t per_phones.date_from%type;

Line 3012: p_phone_type per_phones.phone_type%type;

3008:
3009: p_phone_id per_phones.phone_id%type;
3010: p_phn_date_from per_phones.date_from%type;
3011: p_phn_date_to per_phones.date_to%type;
3012: p_phone_type per_phones.phone_type%type;
3013: p_phone_number per_phones.phone_number%type;
3014:
3015: p_phn_date_from_t per_phones.date_from%type;
3016: p_phn_date_to_t per_phones.date_to%type;

Line 3013: p_phone_number per_phones.phone_number%type;

3009: p_phone_id per_phones.phone_id%type;
3010: p_phn_date_from per_phones.date_from%type;
3011: p_phn_date_to per_phones.date_to%type;
3012: p_phone_type per_phones.phone_type%type;
3013: p_phone_number per_phones.phone_number%type;
3014:
3015: p_phn_date_from_t per_phones.date_from%type;
3016: p_phn_date_to_t per_phones.date_to%type;
3017: p_phone_type_t per_phones.phone_type%type;

Line 3015: p_phn_date_from_t per_phones.date_from%type;

3011: p_phn_date_to per_phones.date_to%type;
3012: p_phone_type per_phones.phone_type%type;
3013: p_phone_number per_phones.phone_number%type;
3014:
3015: p_phn_date_from_t per_phones.date_from%type;
3016: p_phn_date_to_t per_phones.date_to%type;
3017: p_phone_type_t per_phones.phone_type%type;
3018: p_phone_number_t per_phones.phone_number%type;
3019:

Line 3016: p_phn_date_to_t per_phones.date_to%type;

3012: p_phone_type per_phones.phone_type%type;
3013: p_phone_number per_phones.phone_number%type;
3014:
3015: p_phn_date_from_t per_phones.date_from%type;
3016: p_phn_date_to_t per_phones.date_to%type;
3017: p_phone_type_t per_phones.phone_type%type;
3018: p_phone_number_t per_phones.phone_number%type;
3019:
3020: Cursor Csr_phone_Data(P_Person_Id Number,P_phone_Id number,P_Eff_St_Dt Date ) Is

Line 3017: p_phone_type_t per_phones.phone_type%type;

3013: p_phone_number per_phones.phone_number%type;
3014:
3015: p_phn_date_from_t per_phones.date_from%type;
3016: p_phn_date_to_t per_phones.date_to%type;
3017: p_phone_type_t per_phones.phone_type%type;
3018: p_phone_number_t per_phones.phone_number%type;
3019:
3020: Cursor Csr_phone_Data(P_Person_Id Number,P_phone_Id number,P_Eff_St_Dt Date ) Is
3021: Select

Line 3018: p_phone_number_t per_phones.phone_number%type;

3014:
3015: p_phn_date_from_t per_phones.date_from%type;
3016: p_phn_date_to_t per_phones.date_to%type;
3017: p_phone_type_t per_phones.phone_type%type;
3018: p_phone_number_t per_phones.phone_number%type;
3019:
3020: Cursor Csr_phone_Data(P_Person_Id Number,P_phone_Id number,P_Eff_St_Dt Date ) Is
3021: Select
3022: ppn.date_from ,

Line 3026: FROM per_phones ppn

3022: ppn.date_from ,
3023: ppn.date_to ,
3024: PHONE_TYPE,
3025: PHONE_NUMBER
3026: FROM per_phones ppn
3027: where ppn.PARENT_ID = P_PERSON_ID
3028: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
3029: and P_Eff_St_Dt between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3030: