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 HR_ORGANIZATION_INFORMATION

Line 73: HR_ORGANIZATION_INFORMATION HOI1, -- gre / legal entity classification

69: PAY_ASSIGNMENT_ACTIONS PAA2, -- MWR assignment action
70: PAY_ASSIGNMENT_ACTIONS PAA1, -- SQWL assignment action
71: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action
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

Line 74: HR_ORGANIZATION_INFORMATION HOI2, -- Federal employer Identification

70: PAY_ASSIGNMENT_ACTIONS PAA1, -- SQWL assignment action
71: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action
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

Line 75: HR_ORGANIZATION_INFORMATION HOI3 -- state SUI code.

71: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action
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

Line 123: ,hr_organization_information hoi

119: from per_gen_hierarchy pgh
120: ,per_gen_hierarchy_versions pghv
121: ,per_gen_hierarchy_nodes pghn -- parent organization
122: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
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(