DBA Data[Home] [Help]

APPS.GMS_AWARD_DIST_ENG dependencies on GMS_AWARD_DISTRIBUTIONS

Line 293: gms_award_distributions adl

289: NULL,
290: SYSDATE
291: FROM gms_encumbrances_all hdr,
292: gms_encumbrance_items_all dst,
293: gms_award_distributions adl
294: WHERE dst.encumbrance_id = p_header_id
295: AND hdr.encumbrance_id = p_header_id
296: AND hdr.encumbrance_id = dst.encumbrance_id
297: AND adl.expenditure_item_id = dst.encumbrance_item_id

Line 341: gms_award_distributions adl

337: NULL,
338: SYSDATE
339: FROM pa_expenditures_all hdr,
340: pa_expenditure_items_all dst,
341: gms_award_distributions adl
342: WHERE dst.expenditure_id = p_header_id
343: AND hdr.expenditure_id = p_header_id
344: AND hdr.expenditure_id = dst.expenditure_id
345: AND adl.expenditure_item_id = dst.expenditure_item_id