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 54: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(

50: ******************************************************************/
51: cursor US_MWR_SETUP is
52: select 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id
53: from pay_payroll_actions ppa -- MWR payroll action
54: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(
55: 'TRANSFER_PAYROLL_ACTION_ID'); -- MWR payroll action
56:
57:
58: cursor US_MWR_STATE_GRE is

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

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

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

123: ,hr_organization_information hoi
124: ,hr_organization_units hou
125: ,hr_locations loc
126: ,hr_location_extra_info lei
127: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
128: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
129: and pghv.HIERARCHY_VERSION_id = Pay_Magtape_Generic.Get_Parameter_Value(
130: 'TRANSFER_HIERARCHY_VERSION') --parameter p_hierarchy_verision_number
131: and pgh.hierarchy_id = pghv.hierarchy_id

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

125: ,hr_locations loc
126: ,hr_location_extra_info lei
127: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
128: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
129: and pghv.HIERARCHY_VERSION_id = Pay_Magtape_Generic.Get_Parameter_Value(
130: 'TRANSFER_HIERARCHY_VERSION') --parameter p_hierarchy_verision_number
131: and pgh.hierarchy_id = pghv.hierarchy_id
132: and pghv.hierarchy_version_id = pghn.hierarchy_version_id
133: and pghn.node_type = 'PAR'

Line 142: and nvl(loc.loc_information17,loc.region_2) = Pay_Magtape_Generic.Get_Parameter_Value(

138: and pghv.hierarchy_version_id = pghn2.hierarchy_version_id
139: and pghn.business_group_id = pghn2.business_group_id
140: and pghn2.node_type = 'EST'
141: and pghn2.entity_id = loc.location_id
142: and nvl(loc.loc_information17,loc.region_2) = Pay_Magtape_Generic.Get_Parameter_Value(
143: 'TRANSFER_STATE_ABBREV') --#11936382 added nvl(loc.loc_information17)
144: and loc.location_id = lei.location_id
145: and lei.information_type = 'Multi Work Site Information'
146: UNION ALL