APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS

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

328: l_procedure_name VARCHAR2(80);
329:
330: /* Bug 2824397 */
331: /* Bug:2824397. Removed distinct and added rownum join */
332: cursor c_person_id(c_assignment_id per_all_assignments.assignment_id%type) is
333: select person_id
334: from per_assignments_f /* Bug# 2920732 */
335: where assignment_id = c_assignment_id
336: and rownum = 1;

Line 841: per_all_assignments_f paf,

837: SELECT pps.actual_termination_date
838: FROM pay_payroll_actions ppa,
839: pay_assignment_actions paa,
840: per_time_periods ptp,
841: per_all_assignments_f paf,
842: per_periods_of_service pps
843: WHERE paa.assignment_action_id = p_assignment_action_id
844: AND ppa.payroll_action_id = paa.payroll_action_id
845: AND ptp.payroll_id = ppa.payroll_id