APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS

Line 338: cursor c_person_id(c_assignment_id per_all_assignments.assignment_id%type) is

334: l_procedure_name VARCHAR2(80);
335:
336: /* Bug 2824397 */
337: /* Bug:2824397. Removed distinct and added rownum join */
338: cursor c_person_id(c_assignment_id per_all_assignments.assignment_id%type) is
339: select person_id
340: from per_assignments_f /* Bug# 2920732 */
341: where assignment_id = c_assignment_id
342: and rownum = 1;

Line 847: per_all_assignments_f paf,

843: SELECT pps.actual_termination_date
844: FROM pay_payroll_actions ppa,
845: pay_assignment_actions paa,
846: per_time_periods ptp,
847: per_all_assignments_f paf,
848: per_periods_of_service pps
849: WHERE paa.assignment_action_id = p_assignment_action_id
850: AND ppa.payroll_action_id = paa.payroll_action_id
851: AND ptp.payroll_id = ppa.payroll_id