DBA Data[Home] [Help]

APPS.PQH_UTILITY dependencies on GMS_PQH_AWARDS_V

Line 2021: from gms_pqh_awards_v

2017: function GET_PATEO_AWARD_NAME(p_award_id in number,
2018: p_project_id in number,
2019: p_task_id in number) return varchar2 is
2020: cursor c1 is select award_short_name
2021: from gms_pqh_awards_v
2022: where award_id = p_award_id
2023: and project_id = p_project_id
2024: and task_id = p_task_id;
2025: l_name gms_pqh_awards_v.award_short_name%type;

Line 2025: l_name gms_pqh_awards_v.award_short_name%type;

2021: from gms_pqh_awards_v
2022: where award_id = p_award_id
2023: and project_id = p_project_id
2024: and task_id = p_task_id;
2025: l_name gms_pqh_awards_v.award_short_name%type;
2026: begin
2027: if p_award_id is not null and p_task_id is not null and p_project_id is not null then
2028: open c1;
2029: fetch c1 into l_name;