DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 147: from per_org_structure_versions osv, per_organization_structures ors

143: */
144:
145: function get_org_hier(p_org_structure_version_id in number) return varchar2 is
146: cursor c1 is select ors.name
147: from per_org_structure_versions osv, per_organization_structures ors
148: where osv.organization_structure_id = ors.organization_structure_id
149: and osv.org_structure_version_id = p_org_structure_version_id;
150: l_org_hier varchar2(100);
151: begin