APPS.PA_TRANSACTIONS dependencies on GMS_AWARD_DISTRIBUTIONS

Line 1927: adl_rec gms_award_distributions%ROWTYPE; /*added for bug 5769510*/

1923: l_PROJECT_TP_COST_RATE_TYPE VARCHAR2(30);
1924: l_PROJECT_TP_COST_EXG_RATE NUMBER ;
1925: l_PROJECT_TRANSFER_PRICE NUMBER ;
1926: l_gms_enabled VARCHAR(1); /*added for bug 5769510*/
1927: adl_rec gms_award_distributions%ROWTYPE; /*added for bug 5769510*/
1928: source_award_id NUMBER ; /*added for bug 5769510*/
1929: l_cbs_element_id NUMBER ; -- Added for CBS Enhancement Bug 16220146
1930:
1931:

Line 2362: from gms_award_distributions adl

2358: if (x_award_id is NULL) then
2359:
2360: select DISTINCT award_id
2361: into source_award_id
2362: from gms_award_distributions adl
2363: where adl.expenditure_item_id = X_source_exp_item_id
2364: and adl.document_type = 'EXP'
2365: and adl_status = 'A' ;
2366: Else