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 14: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;

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

Line 15: L_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%type;

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

Line 18: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;

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

Line 19: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

15: L_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%type;
16: L_USER_PERSON_TYPE VARCHAR2(60);
17: L_DATE_OF_BIRTH DATE;
18: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
19: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;
20: L_DATE_OF_DEATH DATE;
21: L_ORIGINAL_DATE_OF_HIRE DATE;
22: L_EFFECTIVE_START_DATE DATE;
23: L_SEX VARCHAR2(30);

Line 25: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;

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

Line 26: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;

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

Line 29: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

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

Line 30: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

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

Line 31: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;

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

Line 43: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;

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

Line 47: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;

43: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
44: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
45: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
46: L_NATIONALITY VARCHAR2(30);
47: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
48: L_CONTACT_NAME VARCHAR2(240);
49: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
50: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
51: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

Line 134: from per_addresses padr, per_all_people_f papf

130: l_con_bgid number;
131:
132: cursor csr_check_person_add is
133: select style,ADDRESS_ID
134: from per_addresses padr, per_all_people_f papf
135: where (papf.employee_number = P_EMPLOYEE_NUMBER
136: or papf.npw_number = p_cwk_num )
137: and papf.business_group_id =P_BUSINESS_GROUP_ID
138: AND P_EFFECTIVE_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE

Line 203: FROM PER_ALL_PEOPLE_F ppf,

199: PCR.CONTACT_PERSON_ID,
200: PCR.BUSINESS_GROUP_ID
201:
202:
203: FROM PER_ALL_PEOPLE_F ppf,
204: PER_ALL_PEOPLE_F ppf1,
205: PER_PHONES ppn ,
206: hr_lookups HL1 ,
207: HR_LOOKUPS HL2 ,

Line 204: PER_ALL_PEOPLE_F ppf1,

200: PCR.BUSINESS_GROUP_ID
201:
202:
203: FROM PER_ALL_PEOPLE_F ppf,
204: PER_ALL_PEOPLE_F ppf1,
205: PER_PHONES ppn ,
206: hr_lookups HL1 ,
207: HR_LOOKUPS HL2 ,
208: HR_LOOKUPS HL3 ,

Line 233: FROM PER_ALL_PEOPLE_F PPF1 ,

229: PCR1.BUSINESS_GROUP_ID,
230: C.MEANING,
231: PCR1.CONTACT_PERSON_ID
232:
233: FROM PER_ALL_PEOPLE_F PPF1 ,
234: PER_CONTACT_RELATIONSHIPS PCR1 ,
235: HR_LOOKUPS C
236:
237: WHERE PPF1.PERSON_ID = CONTACT_PERSON_ID

Line 248: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

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

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

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

Line 347: FROM per_all_assignments_f papf , per_all_people_f ppf ,

343:
344: SELECT ppf.full_name,
345: decode ( ppf.CURRENT_NPW_FLAG , 'Y',ppf.NPW_NUMBER,ppf.EMPLOYEE_NUMBER) employee_number ,
346: NVL(AMDTL.USER_STATUS , STTL.USER_STATUS) ASSIGNMENT_STATUS
347: FROM per_all_assignments_f papf , per_all_people_f ppf ,
348: PER_ASSIGNMENT_STATUS_TYPES ST ,
349: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
350: PER_ASS_STATUS_TYPE_AMENDS AMD,
351: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL