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_INITIAL_LOAD dependencies on PER_PHONES

Line 574: p_phone_type per_phones.phone_type%type,

570: (
571:
572: p_phn_date_from varchar2(10),
573: p_phn_date_to varchar2(10),
574: p_phone_type per_phones.phone_type%type,
575: p_phone_no per_phones.phone_number%type);
576:
577: TYPE phone_record is table of PHONE index by binary_integer;
578:

Line 575: p_phone_no per_phones.phone_number%type);

571:
572: p_phn_date_from varchar2(10),
573: p_phn_date_to varchar2(10),
574: p_phone_type per_phones.phone_type%type,
575: p_phone_no per_phones.phone_number%type);
576:
577: TYPE phone_record is table of PHONE index by binary_integer;
578:
579: p_addr_type address_record;

Line 647: FROM per_phones ppn

643: to_char(ppn.date_from,'YYYY-MM-DD'),
644: to_char(ppn.date_to,'YYYY-MM-DD'),
645: PHONE_TYPE,
646: PHONE_NUMBER
647: FROM per_phones ppn
648: where ppn.PARENT_ID (+) = P_PERSON_ID
649: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
650: AND DATE_FROM between P_Eff_St_Dt and P_Eff_End_Dt;
651: