DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_PRSI_DETAILS

Line 4595: ,pay_ie_p45_prsi_details emp_prsi

4591: ,per_time_periods ptp
4592: ,pay_ie_p45_address_details emp_address
4593: ,pay_ie_p45_employee_details emp_details
4594: ,pay_ie_p45_soc_ben_details emp_soc
4595: ,pay_ie_p45_prsi_details emp_prsi
4596: ,pay_ie_p45_paye_details emp_paye
4597: ,pay_ie_p45_supp_details emp_supp
4598: WHERE paa.payroll_action_id = c_p45_arch_id
4599: AND paa.assignment_action_id = pai_arc.locking_action_id

Line 4728: FROM pay_ie_p45_prsi_details emp_prsi

4724: , (round(to_number(emp_paye.this_usc_pay),2)*100) thisuscpay
4725: , (round(to_number(emp_paye.this_usc),2)*100) thisusc
4726: , (round(to_number(emp_paye.total_usc_pay),2)*100) totaluscpay
4727: , (round(to_number(emp_paye.total_usc),2)*100) totalusc
4728: FROM pay_ie_p45_prsi_details emp_prsi
4729: ,pay_ie_p45_paye_details emp_paye
4730: WHERE emp_prsi.assignment_action_id = p_assignment_action_id
4731: AND emp_paye.assignment_action_id = p_assignment_action_id;
4732: cur_p45_paye_prsi_rec cur_p45_paye_prsi_details%ROWTYPE;