APPS.GMS_POR_API dependencies on GMS_AWARDS_ALL

Line 17: from gms_awards_all

13: return VARCHAR2 IS
14:
15: cursor c_award_number is
16: select award_number
17: from gms_awards_all
18: where award_id = X_award_id ;
19:
20: cursor c_adl_award is
21: select a.award_number

Line 22: from gms_awards_all a,

18: where award_id = X_award_id ;
19:
20: cursor c_adl_award is
21: select a.award_number
22: from gms_awards_all a,
23: gms_award_distributions adl
24: where adl.award_set_id = X_award_set_id
25: and adl_status = 'A'
26: and adl_line_num = 1

Line 31: from gms_awards_all a,

27: and adl.award_id = a.award_id ;
28:
29: cursor c_req_award is
30: select a.award_number
31: from gms_awards_all a,
32: gms_award_distributions adl ,
33: po_req_distributions_all req
34: where adl.award_set_id = req.award_id
35: and req.distribution_id = X_req_distribution_id

Line 116: from gms_awards_all

112: return NUMBER IS
113:
114: cursor c_award_id is
115: select award_id
116: from gms_awards_all
117: where award_number = X_award_number ;
118:
119: cursor c_adl_award is
120: select adl.award_id

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

975: p_expenditure_type IN VARCHAR2,
976: p_status IN OUT NOCOPY VARCHAR2,
977: p_err_msg_label OUT NOCOPY VARCHAR2 )
978: AS
979: l_award_id gms_awards_all.award_id%TYPE:=p_award_id;
980: l_dummy NUMBER;
981: l_exp_type gms_allowable_expenditures.expenditure_type%TYPE;
982: l_msg_label VARCHAR2(50);
983: l_status VARCHAR2(1);

Line 1251: gms_awards_all a

1247: l_award_qty_obj.award_id,
1248: l_award_qty_obj.quantity
1249: FROM gms_distribution_details awdd,
1250: gms_distributions awd,
1251: gms_awards_all a
1252: WHERE awd.document_distribution_id = awdd.document_distribution_id
1253: AND awd.document_header_id = awdd.document_header_id
1254: AND awd.document_distribution_id = l_distribution_id
1255: AND awd.document_header_id = l_doc_header_id