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

Line 42: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;

38: L_REGION_1 PER_ADDRESSES.REGION_1%type;
39: L_REGION_2 PER_ADDRESSES.REGION_1%type;
40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
41: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
42: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
43: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
44: L_NATIONALITY VARCHAR2(30);
45: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
46: L_CONTACT_NAME VARCHAR2(240);

Line 43: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;

39: L_REGION_2 PER_ADDRESSES.REGION_1%type;
40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
41: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
42: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
43: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
44: L_NATIONALITY VARCHAR2(30);
45: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
46: L_CONTACT_NAME VARCHAR2(240);
47: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

Line 202: PER_PHONES ppn ,

198:
199:
200: FROM PER_ALL_PEOPLE_F ppf,
201: PER_ALL_PEOPLE_F ppf1,
202: PER_PHONES ppn ,
203: hr_lookups HL1 ,
204: HR_LOOKUPS HL2 ,
205: HR_LOOKUPS HL3 ,
206: HR_LOOKUPS HL4 ,