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 68: HR_ORGANIZATION_INFORMATION HOI1, -- gre / legal entity classification

64: PAY_ASSIGNMENT_ACTIONS PAA2, -- MWR assignment action
65: PAY_ASSIGNMENT_ACTIONS PAA1, -- SQWL assignment action
66: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action
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

Line 69: HR_ORGANIZATION_INFORMATION HOI2, -- Federal employer Identification

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

Line 70: HR_ORGANIZATION_INFORMATION HOI3 -- state SUI code.

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

Line 118: ,hr_organization_information hoi

114: from per_gen_hierarchy pgh
115: ,per_gen_hierarchy_versions pghv
116: ,per_gen_hierarchy_nodes pghn -- parent organization
117: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
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(