DBA Data[Home] [Help]

APPS.PQH_UTILITY dependencies on GMS_PQH_PROJECTS_V

Line 1989: from gms_pqh_projects_v

1985: end is_pqh_installed;
1986: --
1987: function GET_PATEO_PROJECT_NAME(p_project_id in number) return varchar2 is
1988: cursor c1 is select project_name
1989: from gms_pqh_projects_v
1990: where project_id = p_project_id;
1991: l_name gms_pqh_projects_v.project_name%type;
1992: begin
1993: if p_project_id is not null then

Line 1991: l_name gms_pqh_projects_v.project_name%type;

1987: function GET_PATEO_PROJECT_NAME(p_project_id in number) return varchar2 is
1988: cursor c1 is select project_name
1989: from gms_pqh_projects_v
1990: where project_id = p_project_id;
1991: l_name gms_pqh_projects_v.project_name%type;
1992: begin
1993: if p_project_id is not null then
1994: open c1;
1995: fetch c1 into l_name;