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_MAGTAPE_GENERIC

Line 35: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

31: FROM pay_payroll_actions ppa
32: ,hr_organization_units hou
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(+)

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'),

Line 73: where act.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

69: per_all_assignments_f assign,
70: per_all_people_f people,
71: per_addresses pad,
72: pay_all_payrolls_f ppayf
73: where act.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
74: and ppa.payroll_action_id = act.payroll_action_id
75: and act.assignment_id = assign.assignment_id
76: and ppayf.payroll_id = assign.payroll_id
77: and assign.person_id = people.person_id