APPS.GMS_ACC_GEN_API dependencies on GMS_AWARD_DISTRIBUTIONS

Line 20: FROM gms_award_distributions

16:
17:
18: CURSOR C_exp_award is
19: SELECT award_id
20: FROM gms_award_distributions
21: WHERE document_type = x_doc_type
22: and expenditure_item_id = x_exp_item_id
23: and nvl(cdl_line_num,1) = NVL(x_cdl_line_num,1)
24: and ADL_STATUS = 'A' ;

Line 85: from gms_award_distributions

81:
82: -- Bug 2930402 fix : The cursor below is not required.
83: cursor get_award_id_w_doc_type (p_award_set_id in NUMBER, p_document_type in varchar2) is
84: select award_id
85: from gms_award_distributions
86: where award_set_id = p_award_set_id
87: and document_type = p_document_type
88: and adl_status = 'A'
89: and adl_line_num = 1;

Line 93: from gms_award_distributions

89: and adl_line_num = 1;
90:
91: cursor get_award_id_wo_doc_type (p_award_set_id in NUMBER) is
92: select award_id
93: from gms_award_distributions
94: where award_set_id = p_award_set_id
95: -- and adl_status = 'A' -- Bug 2930402 fix.
96: and adl_line_num = 1;
97:

Line 226: from gms_award_distributions

222: l_doc_type varchar2(3) ;
223:
224: CURSOR GET_DOC_TYPE (p_award_set_id in NUMBER) is
225: select document_type
226: from gms_award_distributions
227: where award_set_id = p_award_set_id
228: and adl_status = 'A'
229: and adl_line_num = 1;
230:

Line 309: FROM gms_award_distributions

305: IF NVL(x_doc_type,'X') in ( 'PO','REQ','AP' ) THEN
306:
307: SELECT award_id
308: INTO x_award_id
309: FROM gms_award_distributions
310: WHERE award_set_id = x_award_set_id
311: and document_type = x_doc_type
312: and adl_status = 'A'
313: and adl_line_num = 1 ;

Line 339: FROM gms_award_distributions

335: IF NVL(x_doc_type,'X') in ( 'EXP' , 'ENC' ) THEN
336:
337: SELECT award_id
338: INTO x_award_id
339: FROM gms_award_distributions
340: WHERE expenditure_item_id = NVL( x_exp_enc_item_id, 0)
341: AND nvl(cdl_line_num, 1) = NVL(x_cdl_line,1) --Bug 5726575
342: AND document_type = x_doc_type
343: and adl_status = 'A' ;