APPS.GMS_BILLING_ADJUSTMENTS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 926: -- PA_EXPENDITURE_ITEMS_ALL would not be updated

922: End If;
923:
924: Elsif X_Calling_Process = 'Revenue' then
925:
926: -- PA_EXPENDITURE_ITEMS_ALL would not be updated
927: /*
928: UPDATE PA_EXPENDITURE_ITEMS_ALL
929: set
930: revenue_distributed_flag = 'N'

Line 928: UPDATE PA_EXPENDITURE_ITEMS_ALL

924: Elsif X_Calling_Process = 'Revenue' then
925:
926: -- PA_EXPENDITURE_ITEMS_ALL would not be updated
927: /*
928: UPDATE PA_EXPENDITURE_ITEMS_ALL
929: set
930: revenue_distributed_flag = 'N'
931: ,last_update_date = sysdate
932: ,last_updated_by = fnd_global.user_id

Line 1085: from pa_expenditure_items_all

1081: If X_Expenditure_Item_Id is not null then
1082: -- Cost Based
1083: Select trunc(expenditure_item_date)
1084: into X_creation_date
1085: from pa_expenditure_items_all
1086: where Expenditure_Item_Id = X_Expenditure_Item_Id;
1087: End If;
1088:
1089: X_Err_Code := 0;

Line 1356: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */

1352: F_request_id; -- 4594090
1353:
1354: EXIT WHEN IDENT_INV_INTRSCT_ITEMS%NOTFOUND;
1355:
1356: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */
1357: UPD_PA_EXP_AND_ADL(F_Award_Project_id,
1358: F_Expenditure_Item_Id,
1359: F_Adl_Line_No,
1360: X_Calling_Process,

Line 1755: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */

1751: F_Rev_Accumulated,
1752: F_request_id; -- 4594090
1753: EXIT WHEN IDENT_REV_INTRSCT_ITEMS%NOTFOUND;
1754:
1755: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */
1756: UPD_PA_EXP_AND_ADL(F_Award_Project_id,
1757: F_Expenditure_Item_Id,
1758: F_Adl_Line_No,
1759: X_Calling_Process,