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

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

30: , HR_ORGANIZATION_INFORMATION hoi1
31: , HR_ORGANIZATION_INFORMATION hoi2
32: , HR_LOCATIONS loc
33: , PAY_PAYROLL_ACTIONS ppa
34: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
35: and hou1.business_group_id = ppa.BUSINESS_GROUP_ID
36: and hou1.organization_id = nvl(PAY_DK_TAX_CARD_REQUEST_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),hou1.organization_id)
37: and hou1.location_id = loc.LOCATION_ID(+)
38: and hoi1.organization_id = hou1.organization_id

Line 57: WHERE PPA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

53: , pay_payroll_actions PPA
54: , HR_ORGANIZATION_UNITS hou
55: , HR_ORGANIZATION_INFORMATION hoi1
56: , HR_ORGANIZATION_INFORMATION hoi2
57: WHERE PPA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
58: and PAA.business_group_id = PPA.business_group_id
59: AND PAP.per_information_category ='DK'
60: AND PAA.PERSON_ID = PAP.PERSON_ID
61: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id

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

67: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
68: and hoi1.ORG_INFORMATION2 = 'Y'
69: and hoi2.ORG_INFORMATION_CONTEXT='DK_LEGAL_ENTITY_DETAILS'
70: and hoi2.organization_id = hoi1.organization_id
71: and nvl(hoi2.org_information1,0)= nvl2(PAY_DK_TAX_CARD_REQUEST_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),pay_magtape_generic.get_parameter_value('TRANSFER_CVRNO'),nvl(hoi2.org_information1,0) )
72: and ppa.EFFECTIVE_DATE BETWEEN hou.DATE_FROM and nvl(hou.DATE_TO, ppa.EFFECTIVE_DATE)
73: AND SCL.ENABLED_FLAG = 'Y'
74: AND SCL.SEGMENT1 =to_char(hou.ORGANIZATION_ID);
75: