APPS.GMS_POR_API dependencies on GMS_AWARDS_ALL

Line 23: from gms_awards_all

19: return VARCHAR2 IS
20:
21: cursor c_award_number is
22: select award_number
23: from gms_awards_all
24: where award_id = X_award_id ;
25:
26: cursor c_adl_award is
27: select a.award_number

Line 28: from gms_awards_all a,

24: where award_id = X_award_id ;
25:
26: cursor c_adl_award is
27: select a.award_number
28: from gms_awards_all a,
29: gms_award_distributions adl
30: where adl.award_set_id = X_award_set_id
31: and adl_status = 'A'
32: and adl_line_num = 1

Line 37: from gms_awards_all a,

33: and adl.award_id = a.award_id ;
34:
35: cursor c_req_award is
36: select a.award_number
37: from gms_awards_all a,
38: gms_award_distributions adl ,
39: po_req_distributions_all req
40: where adl.award_set_id = req.award_id
41: and req.distribution_id = X_req_distribution_id

Line 142: from gms_awards_all

138: return NUMBER IS
139:
140: cursor c_award_id is
141: select award_id
142: from gms_awards_all
143: where award_number = X_award_number ;
144:
145: cursor c_adl_award is
146: select adl.award_id

Line 1182: l_award_id gms_awards_all.award_id%TYPE:=p_award_id;

1178: p_expenditure_type IN VARCHAR2,
1179: p_status IN OUT NOCOPY VARCHAR2,
1180: p_err_msg_label OUT NOCOPY VARCHAR2 )
1181: AS
1182: l_award_id gms_awards_all.award_id%TYPE:=p_award_id;
1183: l_dummy NUMBER;
1184: l_exp_type gms_allowable_expenditures.expenditure_type%TYPE;
1185: l_msg_label VARCHAR2(50);
1186: l_status VARCHAR2(1);

Line 1528: gms_awards_all a

1524: l_award_qty_obj.award_id,
1525: l_award_qty_obj.quantity
1526: FROM gms_distribution_details awdd,
1527: gms_distributions awd,
1528: gms_awards_all a
1529: WHERE awd.document_distribution_id = awdd.document_distribution_id
1530: AND awd.document_header_id = awdd.document_header_id
1531: AND awd.document_distribution_id = l_distribution_id
1532: AND awd.document_header_id = l_doc_header_id