APPS.PAY_US_SQWL_UDF dependencies on PER_GEN_HIERARCHY

Line 914: from per_gen_hierarchy pgh

910:
911:
912: CURSOR c_get_reporting_unit_no(cp_location_id number) IS
913: Select lpad(nvl(lei.lei_information1,'0001'),4,'0')
914: from per_gen_hierarchy pgh
915: ,per_gen_hierarchy_versions pghv
916: ,per_gen_hierarchy_nodes pghn -- parent organization
917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
918: ,hr_organization_information hoi

Line 915: ,per_gen_hierarchy_versions pghv

911:
912: CURSOR c_get_reporting_unit_no(cp_location_id number) IS
913: Select lpad(nvl(lei.lei_information1,'0001'),4,'0')
914: from per_gen_hierarchy pgh
915: ,per_gen_hierarchy_versions pghv
916: ,per_gen_hierarchy_nodes pghn -- parent organization
917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
918: ,hr_organization_information hoi
919: ,hr_organization_units hou

Line 916: ,per_gen_hierarchy_nodes pghn -- parent organization

912: CURSOR c_get_reporting_unit_no(cp_location_id number) IS
913: Select lpad(nvl(lei.lei_information1,'0001'),4,'0')
914: from per_gen_hierarchy pgh
915: ,per_gen_hierarchy_versions pghv
916: ,per_gen_hierarchy_nodes pghn -- parent organization
917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
918: ,hr_organization_information hoi
919: ,hr_organization_units hou
920: ,hr_locations loc

Line 917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations

913: Select lpad(nvl(lei.lei_information1,'0001'),4,'0')
914: from per_gen_hierarchy pgh
915: ,per_gen_hierarchy_versions pghv
916: ,per_gen_hierarchy_nodes pghn -- parent organization
917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
918: ,hr_organization_information hoi
919: ,hr_organization_units hou
920: ,hr_locations loc
921: ,hr_location_extra_info lei