DBA Data[Home] [Help]

APPS.PA_REVENUE_AMT dependencies on PA_DRAFT_REVENUE_ITEMS

Line 1012: l_message_code := 'Error in update on pa_draft_revenue_items';

1008: exp_cur_rec.DRAFT_REVENUE_NUM
1009: AND l.draft_revenue_item_line_num =
1010: exp_cur_rec.DRAFT_REVENUE_ITEM_LINE_NUM;
1011:
1012: l_message_code := 'Error in update on pa_draft_revenue_items';
1013:
1014: UPDATE pa_draft_revenue_items i
1015: SET i.amount = i.amount - roundoff_amount,
1016: i.projfunc_revenue_amount = -- Below lines added for Bug 5042421

Line 1014: UPDATE pa_draft_revenue_items i

1010: exp_cur_rec.DRAFT_REVENUE_ITEM_LINE_NUM;
1011:
1012: l_message_code := 'Error in update on pa_draft_revenue_items';
1013:
1014: UPDATE pa_draft_revenue_items i
1015: SET i.amount = i.amount - roundoff_amount,
1016: i.projfunc_revenue_amount = -- Below lines added for Bug 5042421
1017: DECODE(i.revproc_currency_code, i.projfunc_currency_code,
1018: i.amount - roundoff_amount,