APPS.PAY_ZA_EOY_VAL dependencies on PER_ALL_PEOPLE_F

Line 696: l_empno per_all_people_f.employee_number%type;

692: TYPE med_code_tab IS TABLE OF NUMBER Index BY PLS_INTEGER;
693: med_code_t med_code_tab ;
694: retiremnt_fund_lmpsum med_code_tab;
695:
696: l_empno per_all_people_f.employee_number%type;
697: l_assgno per_all_assignments_f.assignment_number%type;
698: l_tax_ytd ff_archive_items.value%TYPE ; -- to save Tax paid by employee during tax year
699: l_site ff_archive_items.value%TYPE ;
700: l_paye ff_archive_items.value%TYPE ;

Line 712: per_all_people_f per,

708: CURSOR emp_number_cur ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
709: SELECT per.employee_number empno, asgn2.assignment_number assgno
710: FROM pay_assignment_actions paa,
711: per_all_assignments_f asgn2,
712: per_all_people_f per,
713: pay_payroll_actions ppa
714: WHERE paa.assignment_action_id = asgn_ac_id
715: AND ppa.payroll_action_id = paa.payroll_action_id
716: AND asgn2.assignment_id = paa.assignment_id

Line 726: from per_all_people_f per2

722: and paf2.assignment_id = asgn2.assignment_id
723: )
724: AND per.effective_start_date =
725: ( select max(per2.effective_start_date)
726: from per_all_people_f per2
727: where per2.effective_start_date <= ppa.effective_date
728: and per2.person_id = per.person_id
729: );
730: --End changes for Bug No 6749775