APPS.GMS_AWARD_DIST_ENG dependencies on GMS_AWARDS_ALL

Line 1232: GMS_AWARDS_ALL GA -- Bug 3221039

1228: --TXN.EXPENDITURE_ITEM_DATE ,
1229: --TXN.PROJECT_NUMBER
1230: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1231: GMS_DISTRIBUTION_DETAILS GTN,
1232: GMS_AWARDS_ALL GA -- Bug 3221039
1233: WHERE GTN.document_header_id = p_xface_id
1234: AND GA.award_id = GTN.award_id -- Bug 3221039
1235: AND TXN.transaction_source = P_transaction_source
1236: AND GTN.document_type = 'EXP'

Line 2357: gms_awards_all GA

2353:
2354: update gms_transaction_interface_all A
2355: set (a.award_id,a.award_number) = ( select B.award_id,GA.award_number -- Bug 3221039
2356: from gms_distribution_details B,
2357: gms_awards_all GA
2358: where a.txn_interface_id = b.document_distribution_id
2359: and B.document_header_id = P_xface_id
2360: and B.distribution_number= 1
2361: and B.document_type = 'EXP'