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_WNU_EDI dependencies on PAY_IE_ARCHIVE_DETAIL_PKG

Line 37: AND hoi.organization_id=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_REF')

33: ,hr_organization_information hoi
34: ,hr_locations_all hlo
35: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
36: AND hou.business_group_id= ppa.business_group_id
37: AND hoi.organization_id=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'EMP_REF')
38: AND hou.organization_id =hoi.organization_id
39: AND hou.location_id = hlo.location_id(+)
40: AND hoi.org_information_context = 'IE_EMPLOYER_INFO'; --Bug 4369280
41: -- AND hoi.organization_id =hou.organization_id

Line 43: --AND hoi.org_information1=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'TAX_REF')

39: AND hou.location_id = hlo.location_id(+)
40: AND hoi.org_information_context = 'IE_EMPLOYER_INFO'; --Bug 4369280
41: -- AND hoi.organization_id =hou.organization_id
42: --For bug Fix 3567562 added join to filter record based on Tax District and PAYE Reference specified as parameters.
43: --AND hoi.org_information1=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'TAX_REF')
44: --AND hoi.org_information2=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'PAYE_REF');
45: --
46: CURSOR CSR_WNU_DETAIL IS
47: select

Line 44: --AND hoi.org_information2=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'PAYE_REF');

40: AND hoi.org_information_context = 'IE_EMPLOYER_INFO'; --Bug 4369280
41: -- AND hoi.organization_id =hou.organization_id
42: --For bug Fix 3567562 added join to filter record based on Tax District and PAYE Reference specified as parameters.
43: --AND hoi.org_information1=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'TAX_REF')
44: --AND hoi.org_information2=pay_ie_archive_detail_pkg.get_parameter(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),'PAYE_REF');
45: --
46: CURSOR CSR_WNU_DETAIL IS
47: select
48: upper('RSI_NUMBER=P'),