APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PER_PEOPLE_F

Line 1302: FROM per_people_f papf,

1298: FUNCTION get_first_name(p_run_assignment_action_id NUMBER) RETURN VARCHAR2
1299: IS
1300: CURSOR csr_first_name IS
1301: SELECT substr(papf.first_name||' '||papf.middle_names,1,20)
1302: FROM per_people_f papf,
1303: per_assignments_f paf,
1304: pay_assignment_actions paa,
1305: pay_payroll_actions ppa
1306: WHERE paa.assignment_action_id = p_run_assignment_action_id

Line 1341: FROM per_people_f papf,

1337: FUNCTION get_last_name(p_run_assignment_action_id NUMBER) RETURN VARCHAR2
1338: IS
1339: CURSOR csr_last_name is
1340: SELECT substr(papf.last_name,1,20)
1341: FROM per_people_f papf,
1342: per_assignments_f paf,
1343: pay_assignment_actions paa,
1344: pay_payroll_actions ppa
1345: WHERE paa.assignment_action_id = p_run_assignment_action_id

Line 1381: FROM per_people_f papf,

1377:
1378: -- Used per_all_assignments_f 4555600
1379: CURSOR csr_dob IS
1380: SELECT to_char(papf.date_of_birth,'dd-mon-yyyy')
1381: FROM per_people_f papf,
1382: per_assignments_f paf,
1383: pay_assignment_actions paa,
1384: pay_payroll_actions ppa
1385: WHERE paa.assignment_action_id = p_run_assignment_action_id

Line 2342: FROM per_people_f ppf,

2338:
2339: END LOOP;
2340:
2341: sqlstr := 'SELECT DISTINCT person_id
2342: FROM per_people_f ppf,
2343: pay_payroll_actions ppa
2344: WHERE ppa.payroll_action_id = :payroll_action_id
2345: AND ppa.business_group_id +0= ppf.business_group_id
2346: ORDER BY ppf.person_id'; */

Line 2370: FROM per_people_f ppf,

2366: -- The Payroll ID was used as parameter, so restrict by this
2367: --
2368: hr_utility.trace('Range Cursor using Payroll Restriction');
2369: sqlstr := 'SELECT DISTINCT ppf.person_id
2370: FROM per_people_f ppf,
2371: pay_payroll_actions ppa,
2372: per_assignments_f paaf
2373: WHERE ppa.payroll_action_id = :payroll_action_id
2374: AND ppf.business_group_id +0 = ppa.business_group_id