APPS.GMS_PO_ADL_PKG dependencies on GMS_AWARD_DISTRIBUTIONS

Line 96: insert into gms_award_distributions

92: FOR C_REC IN C_REQ_REC LOOP
93:
94: x_award_set_id := gms_awards_dist_pkg.get_award_set_id ;
95:
96: insert into gms_award_distributions
97: ( AWARD_SET_ID ,
98: ADL_LINE_NUM ,
99: FUNDING_PATTERN_ID ,
100: DISTRIBUTION_VALUE ,

Line 185: from gms_award_distributions adl

181: NVL(fnd_global.user_id,0) ,
182: SYSDATE ,
183: LAST_UPDATE_LOGIN ,
184: BUD_TASK_ID
185: from gms_award_distributions adl
186: where adl.award_set_id = c_rec.award_set_id
187: and adl.adl_status = 'A'
188: and adl.document_type = 'REQ'
189: and adl.distribution_id = c_rec.old_distribution_id

Line 191: from gms_award_distributions adl2

187: and adl.adl_status = 'A'
188: and adl.document_type = 'REQ'
189: and adl.distribution_id = c_rec.old_distribution_id
190: and NOT EXISTS ( select 'X'
191: from gms_award_distributions adl2
192: where adl2.distribution_id = c_rec.new_distribution_id
193: and adl2.adl_status = 'A'
194: and adl2.document_type = 'REQ'
195: ) ;

Line 202: from gms_award_distributions adl2

198: SET award_id = x_award_set_id
199: WHERE distribution_id = c_rec.new_distribution_id
200: AND award_id IS NULL
201: and EXISTS ( select 'X'
202: from gms_award_distributions adl2
203: where adl2.distribution_id = c_rec.new_distribution_id
204: and adl2.adl_status = 'A'
205: and award_set_id = x_award_set_id
206: and adl2.document_type = 'REQ'