DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_SUPP_DETAILS

Line 4597: ,pay_ie_p45_supp_details emp_supp

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
4600: AND paa_payroll.assignment_action_id = pai_arc.locked_action_id
4601: AND paa.assignment_action_id = pai_iep45.action_context_id

Line 4748: FROM pay_ie_p45_supp_details emp_supp

4744: ,emp_supp.insurable_weeks supp_totalweeks
4745: ,emp_supp.supp_insurable_classA_weeks supp_classA_weeks -- Bug 5015438
4746: ,(round(to_number(emp_supp.total_usc),2)*100) supp_totalusc -- bug 13359530
4747: ,(round(to_number(emp_supp.total_usc_pay),2)*100) supp_totaluscpay
4748: FROM pay_ie_p45_supp_details emp_supp
4749: WHERE emp_supp.assignment_id = p_assignment_id
4750: AND emp_supp.date_paid =p_date_earned
4751: AND emp_supp.pay_period =p_period
4752: AND emp_supp.period_frequency = decode(p_freq,'M','Monthly','Weekly');