eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_SUPP_DETAILS

Line 3674: ,pay_ie_p45_supp_details emp_supp

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
3678: AND paa.assignment_action_id = pai_iep45.action_context_id

Line 3810: FROM pay_ie_p45_supp_details emp_supp

3806: ,(round(to_number(emp_supp.total_employer_prsi),2)*100) supp_totalprsi -- Bug 5005788
3807: ,(round(to_number(emp_supp.total_employee_prsi),2)*100) supp_employeeprsi
3808: ,emp_supp.insurable_weeks supp_totalweeks
3809: ,emp_supp.supp_insurable_classA_weeks supp_classA_weeks -- Bug 5015438
3810: FROM pay_ie_p45_supp_details emp_supp
3811: WHERE emp_supp.assignment_id = p_assignment_id
3812: AND emp_supp.date_paid =p_date_earned
3813: AND emp_supp.pay_period =p_period
3814: AND emp_supp.period_frequency = decode(p_freq,'M','Monthly','Weekly');