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

Line 49: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(

45: ******************************************************************/
46: cursor US_MWR_SETUP is
47: select 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id
48: from pay_payroll_actions ppa -- MWR payroll action
49: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(
50: 'TRANSFER_PAYROLL_ACTION_ID'); -- MWR payroll action
51:
52:
53: cursor US_MWR_STATE_GRE is

Line 71: where ppa2.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(

67: PAY_STATE_RULES PSR,
68: HR_ORGANIZATION_INFORMATION HOI1, -- gre / legal entity classification
69: HR_ORGANIZATION_INFORMATION HOI2, -- Federal employer Identification
70: HR_ORGANIZATION_INFORMATION HOI3 -- state SUI code.
71: where ppa2.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(
72: 'TRANSFER_PAYROLL_ACTION_ID') -- MWR payroll action
73: and ppa2.payroll_action_id = paa2.payroll_action_id
74: -- paa2.serial_number store sqwl locked action
75: and paa2.serial_number = paa1.assignment_action_id

Line 122: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(

118: ,hr_organization_information hoi
119: ,hr_organization_units hou
120: ,hr_locations loc
121: ,hr_location_extra_info lei
122: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
123: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
124: and pghv.HIERARCHY_VERSION_id = Pay_Magtape_Generic.Get_Parameter_Value(
125: 'TRANSFER_HIERARCHY_VERSION') --parameter p_hierarchy_verision_number
126: and pgh.hierarchy_id = pghv.hierarchy_id

Line 124: and pghv.HIERARCHY_VERSION_id = Pay_Magtape_Generic.Get_Parameter_Value(

120: ,hr_locations loc
121: ,hr_location_extra_info lei
122: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
123: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
124: and pghv.HIERARCHY_VERSION_id = Pay_Magtape_Generic.Get_Parameter_Value(
125: 'TRANSFER_HIERARCHY_VERSION') --parameter p_hierarchy_verision_number
126: and pgh.hierarchy_id = pghv.hierarchy_id
127: and pghv.hierarchy_version_id = pghn.hierarchy_version_id
128: and pghn.node_type = 'PAR'

Line 137: and loc.region_2 = Pay_Magtape_Generic.Get_Parameter_Value(

133: and pghv.hierarchy_version_id = pghn2.hierarchy_version_id
134: and pghn.business_group_id = pghn2.business_group_id
135: and pghn2.node_type = 'EST'
136: and pghn2.entity_id = loc.location_id
137: and loc.region_2 = Pay_Magtape_Generic.Get_Parameter_Value(
138: 'TRANSFER_STATE_ABBREV')
139: and loc.location_id = lei.location_id
140: and lei.information_type = 'Multi Work Site Information'
141: UNION ALL