APPS.GMS_POR_API2 dependencies on GMS_PROJECT_TYPES

Line 41: l_spon_flag gms_project_types.sponsored_flag%TYPE ;

37: l_status VARCHAR2(1);
38: l_msg_label VARCHAR2(2000);
39: l_recs_processed NUMBER;
40: l_recs_rejected NUMBER;
41: l_spon_flag gms_project_types.sponsored_flag%TYPE ;
42: l_source_type_code po_requisition_lines_all.source_type_code%type;
43:
44: cursor C_spon_project is
45: select pt.sponsored_flag

Line 47: gms_project_types pt

43:
44: cursor C_spon_project is
45: select pt.sponsored_flag
46: from pa_projects_all b,
47: gms_project_types pt
48: where b.project_id = l_project_id
49: and b.project_type = pt.project_type
50: and pt.sponsored_flag = 'Y' ;
51: CURSOR c_next_header_id IS