APPS.PAY_ZA_EOY_VAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 697: l_assgno per_all_assignments_f.assignment_number%type;

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 ;
701: l_msgtext varchar2(2000);

Line 711: per_all_assignments_f asgn2,

707: --Changes done for Bug No 6749775
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