DBA Data[Home] [Help]

APPS.PQH_UTILITY dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 2059: from pa_organizations_expend_v

2055: end;
2056:
2057: function GET_PATEO_ORGANIZATION_NAME(p_organization_id in number) return varchar2 is
2058: cursor c1 is select name
2059: from pa_organizations_expend_v
2060: where organization_id = p_organization_id;
2061: l_name pa_organizations_expend_v.name%type;
2062: begin
2063: if p_organization_id is not null then

Line 2061: l_name pa_organizations_expend_v.name%type;

2057: function GET_PATEO_ORGANIZATION_NAME(p_organization_id in number) return varchar2 is
2058: cursor c1 is select name
2059: from pa_organizations_expend_v
2060: where organization_id = p_organization_id;
2061: l_name pa_organizations_expend_v.name%type;
2062: begin
2063: if p_organization_id is not null then
2064: open c1;
2065: fetch c1 into l_name;