APPS.PQH_UTILITY dependencies on GMS_PQH_EXP_TYPES_V

Line 2040: from gms_pqh_exp_types_v

2036: p_award_id in number,
2037: p_task_id in number,
2038: p_expenditure_type in varchar2) return varchar2 is
2039: cursor c1 is select expenditure_type
2040: from gms_pqh_exp_types_v
2041: where project_id = p_project_id
2042: and task_id = p_task_id
2043: and award_id = p_award_id
2044: and expenditure_type = p_expenditure_type

Line 2047: l_name gms_pqh_exp_types_v.expenditure_type%type;

2043: and award_id = p_award_id
2044: and expenditure_type = p_expenditure_type
2045: and (sysdate between expnd_typ_start_date_active and
2046: nvl(expnd_typ_end_date_active , sysdate)) ;
2047: l_name gms_pqh_exp_types_v.expenditure_type%type;
2048: begin
2049: if p_project_id is not null and p_award_id is not null and p_task_id is not null and p_expenditure_type is not null then
2050: open c1;
2051: fetch c1 into l_name;