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.PAY_CN_EXT dependencies on PER_ALL_PEOPLE_F

Line 983: l_expat_indicator per_all_people_f.per_information8%TYPE;

979: RETURN VARCHAR2
980: IS
981: --
982:
983: l_expat_indicator per_all_people_f.per_information8%TYPE;
984: l_cont_area hr_soft_coding_keyflex.segment21%TYPE;
985: l_assg_legal_employer NUMBER;
986: l_proc_name VARCHAR2(150);
987: l_return_value CHAR(1);

Line 1014: ,per_all_people_f pap

1010: --
1011: SELECT pap.per_information8 exp_indicator
1012: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1013: FROM per_all_assignments_f paa
1014: ,per_all_people_f pap
1015: ,hr_soft_coding_keyflex hsck
1016: WHERE paa.assignment_id = p_assignment_id
1017: AND paa.business_group_id = p_business_group_id
1018: AND paa.person_id = pap.person_id

Line 1213: l_expat_indicator per_all_people_f.per_information8%TYPE;

1209: RETURN VARCHAR2
1210: IS
1211: --
1212:
1213: l_expat_indicator per_all_people_f.per_information8%TYPE;
1214: l_cont_area hr_soft_coding_keyflex.segment21%TYPE;
1215: l_assg_legal_employer NUMBER;
1216: l_proc_name VARCHAR2(150);
1217: l_return_value CHAR(1);

Line 1244: ,per_all_people_f pap

1240: --
1241: SELECT pap.per_information8 exp_indicator
1242: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1243: FROM per_all_assignments_f paa
1244: ,per_all_people_f pap
1245: ,hr_soft_coding_keyflex hsck
1246: WHERE paa.assignment_id = p_assignment_id
1247: AND paa.business_group_id = p_business_group_id
1248: AND paa.person_id = pap.person_id

Line 1442: l_expat_indicator per_all_people_f.per_information8%TYPE;

1438: l_element_name pay_element_types_f.element_name%TYPE;
1439: l_acct_status VARCHAR2(50);
1440: l_prev_acct_status VARCHAR2(50);
1441: l_reason_of_change VARCHAR2(10);
1442: l_expat_indicator per_all_people_f.per_information8%TYPE;
1443: l_cont_area hr_soft_coding_keyflex.segment21%TYPE;
1444: l_assg_legal_employer NUMBER;
1445: l_proc_name VARCHAR2(150);
1446: l_return_value CHAR(1);

Line 1549: ,per_all_people_f pap

1545: --
1546: SELECT pap.per_information8 exp_indicator
1547: ,fnd_number.canonical_to_number(hsck.segment1) Legal_Employer
1548: FROM per_all_assignments_f paa
1549: ,per_all_people_f pap
1550: ,hr_soft_coding_keyflex hsck
1551: WHERE paa.assignment_id = p_assignment_id
1552: AND paa.business_group_id = p_business_group_id
1553: AND paa.person_id = pap.person_id

Line 2282: ,per_all_people_f pap

2278: IS
2279: --
2280: SELECT hr_general.decode_lookup('CN_RACE',pap.per_information17)
2281: FROM per_all_assignments_f paa
2282: ,per_all_people_f pap
2283: WHERE paa.assignment_id = p_assignment_id
2284: AND pap.person_id = paa.person_id
2285: AND p_date_earned BETWEEN paa.effective_start_date
2286: AND paa.effective_end_date

Line 2299: ,per_all_people_f pap

2295: IS
2296: --
2297: SELECT hr_general.decode_lookup('CN_HUKOU_TYPE',pap.per_information4 )
2298: FROM per_all_assignments_f paa
2299: ,per_all_people_f pap
2300: WHERE paa.assignment_id = p_assignment_id
2301: AND pap.person_id = paa.person_id
2302: AND p_date_earned BETWEEN paa.effective_start_date
2303: AND paa.effective_end_date

Line 2315: ,per_all_people_f pap

2311: IS
2312: --
2313: SELECT ppei.pei_information2 Work_Life_Start_Date
2314: FROM per_all_assignments_f paa
2315: ,per_all_people_f pap
2316: ,per_people_extra_info ppei
2317: WHERE paa.assignment_id = p_assignment_id
2318: AND pap.person_id = paa.person_id
2319: AND ppei.person_id = pap.person_id (+)