DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_PRSI_DETAILS

Line 3672: ,pay_ie_p45_prsi_details emp_prsi

3668: ,per_time_periods ptp
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

Line 3792: FROM pay_ie_p45_prsi_details emp_prsi

3788: ,(round(to_number(emp_prsi.total_employer_prsi),2)*100) employerprsi -- Bug 5005788
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;