APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PER_PEOPLE_F

Line 1081: FROM per_people_f papf,

1077: FUNCTION get_first_name(p_run_assignment_action_id NUMBER) RETURN VARCHAR2
1078: IS
1079: CURSOR csr_first_name IS
1080: SELECT substr(papf.first_name||' '||papf.middle_names,1,20)
1081: FROM per_people_f papf,
1082: per_assignments_f paf,
1083: pay_assignment_actions paa,
1084: pay_payroll_actions ppa
1085: WHERE paa.assignment_action_id = p_run_assignment_action_id

Line 1120: FROM per_people_f papf,

1116: FUNCTION get_last_name(p_run_assignment_action_id NUMBER) RETURN VARCHAR2
1117: IS
1118: CURSOR csr_last_name is
1119: SELECT substr(papf.last_name,1,20)
1120: FROM per_people_f papf,
1121: per_assignments_f paf,
1122: pay_assignment_actions paa,
1123: pay_payroll_actions ppa
1124: WHERE paa.assignment_action_id = p_run_assignment_action_id

Line 1160: FROM per_people_f papf,

1156:
1157: -- Used per_all_assignments_f 4555600
1158: CURSOR csr_dob IS
1159: SELECT to_char(papf.date_of_birth,'dd-mon-yyyy')
1160: FROM per_people_f papf,
1161: per_assignments_f paf,
1162: pay_assignment_actions paa,
1163: pay_payroll_actions ppa
1164: WHERE paa.assignment_action_id = p_run_assignment_action_id

Line 2045: FROM per_people_f ppf,

2041:
2042: END LOOP;
2043:
2044: sqlstr := 'SELECT DISTINCT person_id
2045: FROM per_people_f ppf,
2046: pay_payroll_actions ppa
2047: WHERE ppa.payroll_action_id = :payroll_action_id
2048: AND ppa.business_group_id +0= ppf.business_group_id
2049: ORDER BY ppf.person_id'; */

Line 2073: FROM per_people_f ppf,

2069: -- The Payroll ID was used as parameter, so restrict by this
2070: --
2071: hr_utility.trace('Range Cursor using Payroll Restriction');
2072: sqlstr := 'SELECT DISTINCT ppf.person_id
2073: FROM per_people_f ppf,
2074: pay_payroll_actions ppa,
2075: per_assignments_f paaf
2076: WHERE ppa.payroll_action_id = :payroll_action_id
2077: AND ppf.business_group_id +0 = ppa.business_group_id