APPS.GMS_AWARD_DIST_ENG dependencies on GMS_AWARDS_ALL

Line 1366: GMS_AWARDS_ALL GA -- Bug 3221039

1362: --TXN.EXPENDITURE_ITEM_DATE ,
1363: --TXN.PROJECT_NUMBER
1364: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1365: GMS_DISTRIBUTION_DETAILS GTN,
1366: GMS_AWARDS_ALL GA -- Bug 3221039
1367: WHERE GTN.document_header_id = p_xface_id
1368: AND GA.award_id = GTN.award_id -- Bug 3221039
1369: AND TXN.transaction_source = P_transaction_source
1370: AND GTN.document_type = 'EXP'

Line 2491: gms_awards_all GA

2487:
2488: update gms_transaction_interface_all A
2489: set (a.award_id,a.award_number) = ( select B.award_id,GA.award_number -- Bug 3221039
2490: from gms_distribution_details B,
2491: gms_awards_all GA
2492: where a.txn_interface_id = b.document_distribution_id
2493: and B.document_header_id = P_xface_id
2494: and B.distribution_number= 1
2495: and B.document_type = 'EXP'