DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_PAYE_DETAILS

Line 3673: ,pay_ie_p45_paye_details emp_paye

3669: ,pay_ie_p45_address_details emp_address
3670: ,pay_ie_p45_employee_details emp_details
3671: ,pay_ie_p45_soc_ben_details emp_soc
3672: ,pay_ie_p45_prsi_details emp_prsi
3673: ,pay_ie_p45_paye_details emp_paye
3674: ,pay_ie_p45_supp_details emp_supp
3675: WHERE paa.payroll_action_id = c_p45_arch_id
3676: AND paa.assignment_action_id = pai_arc.locking_action_id
3677: AND paa_payroll.assignment_action_id = pai_arc.locked_action_id

Line 3793: ,pay_ie_p45_paye_details emp_paye

3789: ,(round(to_number(emp_prsi.total_employee_prsi),2)*100) employeeprsi
3790: ,emp_prsi.insurable_weeks totalweeks
3791: ,emp_prsi.class_a_insurable_weeks totalaweeks
3792: FROM pay_ie_p45_prsi_details emp_prsi
3793: ,pay_ie_p45_paye_details emp_paye
3794: WHERE emp_prsi.assignment_action_id = p_assignment_action_id
3795: AND emp_paye.assignment_action_id = p_assignment_action_id;
3796: cur_p45_paye_prsi_rec cur_p45_paye_prsi_details%ROWTYPE;
3797: --