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_DK_MIA_REPORT_PKG dependencies on PAY_MAGTAPE_GENERIC

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

68: , HR_ORGANIZATION_INFORMATION hoi2
69: , HR_LOCATIONS loc
70: , PAY_PAYROLL_ACTIONS ppa
71: WHERE
72: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
73: and hou1.business_group_id = ppa.BUSINESS_GROUP_ID
74: and hou1.organization_id = nvl(PAY_DK_MIA_REPORT_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),hou1.organization_id)
75: and hou1.location_id = loc.LOCATION_ID(+)
76: and hoi1.organization_id = hou1.organization_id

Line 113: --ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

109: , HR_ORGANIZATION_UNITS hou
110: , HR_ORGANIZATION_INFORMATION hoi1
111: , HR_ORGANIZATION_INFORMATION hoi2
112: WHERE
113: --ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
114: ppa.business_group_id = PAY_DK_MIA_REPORT_PKG.get_business_group_id(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
115: --AND PAA.business_group_id = ppa.business_group_id
116: AND PAP.per_information_category ='DK'
117: AND PAA.PERSON_ID = PAP.PERSON_ID

Line 114: ppa.business_group_id = PAY_DK_MIA_REPORT_PKG.get_business_group_id(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))

110: , HR_ORGANIZATION_INFORMATION hoi1
111: , HR_ORGANIZATION_INFORMATION hoi2
112: WHERE
113: --ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
114: ppa.business_group_id = PAY_DK_MIA_REPORT_PKG.get_business_group_id(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
115: --AND PAA.business_group_id = ppa.business_group_id
116: AND PAP.per_information_category ='DK'
117: AND PAA.PERSON_ID = PAP.PERSON_ID
118: AND PPS.person_id = PAP.person_id

Line 140: where payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')),'YYYYMMDD')

136: --AND PPA.EFFECTIVE_DATE between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
137: AND PPA.EFFECTIVE_DATE between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
138: AND to_char(PPA.effective_date,'YYYYMMDD') =
139: to_char((select effective_date from pay_payroll_actions
140: where payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')),'YYYYMMDD')
141: AND PPA.EFFECTIVE_DATE BETWEEN PPS.DATE_START AND NVL(PPS.ACTUAL_TERMINATION_DATE,TO_DATE('31/12/4712','dd/mm/yyyy'))--Check added by pgopal for bug fix-4499107
142: and hou.business_group_id = PPA.business_group_id
143: and hoi1.organization_id = hou.organization_id
144: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 149: and nvl(hoi2.org_information1,0)= nvl2(PAY_DK_MIA_REPORT_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),pay_magtape_generic.get_parameter_value('TRANSFER_CVRNO'),nvl(hoi2.org_information1,0) )

145: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
146: and hoi1.ORG_INFORMATION2 = 'Y'
147: and hoi2.ORG_INFORMATION_CONTEXT='DK_LEGAL_ENTITY_DETAILS'
148: and hoi2.organization_id = hoi1.organization_id
149: and nvl(hoi2.org_information1,0)= nvl2(PAY_DK_MIA_REPORT_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),pay_magtape_generic.get_parameter_value('TRANSFER_CVRNO'),nvl(hoi2.org_information1,0) )
150: and ppa.EFFECTIVE_DATE BETWEEN hou.DATE_FROM and nvl(hou.DATE_TO, ppa.EFFECTIVE_DATE)
151: AND SCL.ENABLED_FLAG = 'Y'
152: AND SCL.SEGMENT1 =to_char(hou.ORGANIZATION_ID)
153: ORDER BY hoi2.ORG_INFORMATION1,PAA.payroll_id,PAP.PERSON_ID;