APPS.PAY_US_MWR_REPORTING_PKG dependencies on PER_GEN_HIERARCHY

Line 119: from per_gen_hierarchy pgh

115: ,'TRANSFER_COMMENTS=P' ,lei.lei_information7
116: ,'TRANSFER_EST_ID=P' ,pghn2.entity_id
117: ,'TRANSFER_REC_COUNT=P' ,pay_us_mwr_reporting_pkg.estab_count
118: ,'TRANSFER_HEADER=P' ,pay_us_mwr_reporting_pkg.est_id
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

Line 120: ,per_gen_hierarchy_versions pghv

116: ,'TRANSFER_EST_ID=P' ,pghn2.entity_id
117: ,'TRANSFER_REC_COUNT=P' ,pay_us_mwr_reporting_pkg.estab_count
118: ,'TRANSFER_HEADER=P' ,pay_us_mwr_reporting_pkg.est_id
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

Line 121: ,per_gen_hierarchy_nodes pghn -- parent organization

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

Line 122: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations

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