APPS.PA_TRANSACTIONS dependencies on GMS_AWARD_DISTRIBUTIONS

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

1806: l_PROJECT_TP_COST_RATE_TYPE VARCHAR2(30);
1807: l_PROJECT_TP_COST_EXG_RATE NUMBER ;
1808: l_PROJECT_TRANSFER_PRICE NUMBER ;
1809: l_gms_enabled VARCHAR(1); /*added for bug 5769510*/
1810: adl_rec gms_award_distributions%ROWTYPE; /*added for bug 5769510*/
1811: source_award_id NUMBER ; /*added for bug 5769510*/
1812:
1813:
1814: BEGIN

Line 2214: from gms_award_distributions adl

2210: if (x_award_id is NULL) then
2211:
2212: select DISTINCT award_id
2213: into source_award_id
2214: from gms_award_distributions adl
2215: where adl.expenditure_item_id = X_source_exp_item_id
2216: and adl.document_type = 'EXP'
2217: and adl_status = 'A' ;
2218: Else