APPS.PAY_CN_EXT dependencies on HR_SOFT_CODING_KEYFLEX

Line 984: l_cont_area hr_soft_coding_keyflex.segment21%TYPE;

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);
988: l_value CHAR(1);

Line 1015: ,hr_soft_coding_keyflex hsck

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
1019: AND paa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 1214: l_cont_area hr_soft_coding_keyflex.segment21%TYPE;

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);
1218: l_value CHAR(1) ;

Line 1245: ,hr_soft_coding_keyflex hsck

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
1249: AND paa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 1443: l_cont_area hr_soft_coding_keyflex.segment21%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);
1447: l_value CHAR(1);

Line 1550: ,hr_soft_coding_keyflex hsck

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
1554: AND paa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id