APPS.GMS_POR_API2 dependencies on GMS_PROJECT_TYPES

Line 47: l_spon_flag gms_project_types.sponsored_flag%TYPE ;

43: l_status VARCHAR2(1);
44: l_msg_label VARCHAR2(2000);
45: l_recs_processed NUMBER;
46: l_recs_rejected NUMBER;
47: l_spon_flag gms_project_types.sponsored_flag%TYPE ;
48: l_source_type_code po_requisition_lines_all.source_type_code%type;
49:
50: cursor C_spon_project is
51: select pt.sponsored_flag

Line 53: gms_project_types pt

49:
50: cursor C_spon_project is
51: select pt.sponsored_flag
52: from pa_projects_all b,
53: gms_project_types pt
54: where b.project_id = l_project_id
55: and b.project_type = pt.project_type
56: and pt.sponsored_flag = 'Y' ;
57: CURSOR c_next_header_id IS