DBA Data[Home] [Help]

APPS.PAY_US_SQWL_UDF dependencies on PER_GEN_HIERARCHY_VERSIONS

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