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_ALL_PEOPLE_F

Line 13: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;

9: is
10:
11: l_params WF_PARAMETER_LIST_T;
12:
13: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
14: L_USER_PERSON_TYPE VARCHAR2(60);
15: L_DATE_OF_BIRTH DATE;
16: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
17: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

Line 16: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;

12:
13: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
14: L_USER_PERSON_TYPE VARCHAR2(60);
15: L_DATE_OF_BIRTH DATE;
16: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
17: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;
18: L_DATE_OF_DEATH DATE;
19: L_ORIGINAL_DATE_OF_HIRE DATE;
20: L_EFFECTIVE_START_DATE DATE;

Line 17: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

13: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
14: L_USER_PERSON_TYPE VARCHAR2(60);
15: L_DATE_OF_BIRTH DATE;
16: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
17: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;
18: L_DATE_OF_DEATH DATE;
19: L_ORIGINAL_DATE_OF_HIRE DATE;
20: L_EFFECTIVE_START_DATE DATE;
21: L_SEX VARCHAR2(30);

Line 23: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;

19: L_ORIGINAL_DATE_OF_HIRE DATE;
20: L_EFFECTIVE_START_DATE DATE;
21: L_SEX VARCHAR2(30);
22: L_MARITAL_STATUS VARCHAR2(30);
23: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
24: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
25: L_SUFFIX VARCHAR2(30);
26: L_TITLE VARCHAR2(30);
27: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

Line 24: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;

20: L_EFFECTIVE_START_DATE DATE;
21: L_SEX VARCHAR2(30);
22: L_MARITAL_STATUS VARCHAR2(30);
23: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
24: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
25: L_SUFFIX VARCHAR2(30);
26: L_TITLE VARCHAR2(30);
27: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
28: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

Line 27: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

23: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
24: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
25: L_SUFFIX VARCHAR2(30);
26: L_TITLE VARCHAR2(30);
27: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
28: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
29: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
31: L_DATE_FROM DATE;

Line 28: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

24: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
25: L_SUFFIX VARCHAR2(30);
26: L_TITLE VARCHAR2(30);
27: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
28: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
29: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
31: L_DATE_FROM DATE;
32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;

Line 29: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;

25: L_SUFFIX VARCHAR2(30);
26: L_TITLE VARCHAR2(30);
27: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
28: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
29: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
31: L_DATE_FROM DATE;
32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

Line 41: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;

37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%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;

Line 45: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%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;
48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

Line 132: from per_addresses padr, per_all_people_f papf

128: l_con_bgid number;
129:
130: cursor csr_check_person_add is
131: select style,ADDRESS_ID
132: from per_addresses padr, per_all_people_f papf
133: where papf.employee_number =P_EMPLOYEE_NUMBER
134: and papf.business_group_id =P_BUSINESS_GROUP_ID
135: AND P_EFFECTIVE_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
136: AND PADR.PERSON_ID=PAPF.PERSON_ID

Line 200: FROM PER_ALL_PEOPLE_F ppf,

196: PCR.CONTACT_PERSON_ID,
197: PCR.BUSINESS_GROUP_ID
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 ,

Line 201: PER_ALL_PEOPLE_F ppf1,

197: PCR.BUSINESS_GROUP_ID
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 ,

Line 230: FROM PER_ALL_PEOPLE_F PPF1 ,

226: PCR1.BUSINESS_GROUP_ID,
227: C.MEANING,
228: PCR1.CONTACT_PERSON_ID
229:
230: FROM PER_ALL_PEOPLE_F PPF1 ,
231: PER_CONTACT_RELATIONSHIPS PCR1 ,
232: HR_LOOKUPS C
233:
234: WHERE PPF1.PERSON_ID = CONTACT_PERSON_ID

Line 245: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

241: WHERE ppn.PARENT_ID (+) = PPF.PERSON_ID
242: -- Modified for the bug 6895752 starts here
243: /*AND ( ppn.parent_id is null
244: OR ( ppn.parent_id is not null
245: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
246: AND PPN.PHONE_TYPE = 'W1' ))*/
247: -- Modified for the bug 6895752 ends here
248:
249: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'

Line 249: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'

245: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
246: AND PPN.PHONE_TYPE = 'W1' ))*/
247: -- Modified for the bug 6895752 ends here
248:
249: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
250: AND PPN.PHONE_TYPE (+) = 'W1'
251:
252: AND HL1.LOOKUP_TYPE (+) = 'SEX'
253: AND HL1.LOOKUP_CODE (+) = ppf.SEX

Line 339: FROM per_all_assignments_f papf , per_all_people_f ppf ,

335: CURSOR CSR_REPORTEES_DATA IS
336:
337: SELECT ppf.full_name, employee_number ,
338: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
339: FROM per_all_assignments_f papf , per_all_people_f ppf ,
340: PER_ASSIGNMENT_STATUS_TYPES ST ,
341: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
342: PER_ASS_STATUS_TYPE_AMENDS AMD,
343: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL