APPS.PAY_US_MWR_REPORTING_PKG dependencies on PER_GEN_HIERARCHY

Line 114: from per_gen_hierarchy pgh

110: ,'TRANSFER_COMMENTS=P' ,lei.lei_information7
111: ,'TRANSFER_EST_ID=P' ,pghn2.entity_id
112: ,'TRANSFER_REC_COUNT=P' ,pay_us_mwr_reporting_pkg.estab_count
113: ,'TRANSFER_HEADER=P' ,pay_us_mwr_reporting_pkg.est_id
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

Line 115: ,per_gen_hierarchy_versions pghv

111: ,'TRANSFER_EST_ID=P' ,pghn2.entity_id
112: ,'TRANSFER_REC_COUNT=P' ,pay_us_mwr_reporting_pkg.estab_count
113: ,'TRANSFER_HEADER=P' ,pay_us_mwr_reporting_pkg.est_id
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

Line 116: ,per_gen_hierarchy_nodes pghn -- parent organization

112: ,'TRANSFER_REC_COUNT=P' ,pay_us_mwr_reporting_pkg.estab_count
113: ,'TRANSFER_HEADER=P' ,pay_us_mwr_reporting_pkg.est_id
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

Line 117: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations

113: ,'TRANSFER_HEADER=P' ,pay_us_mwr_reporting_pkg.est_id
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