DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURE_COMMENTS

Line 547: INSERT INTO pa_expenditure_comments (

543: IF P_DEBUG_MODE THEN
544: pa_cc_utils.log_message('InsItemComment: ' || 'Start ');
545: END IF;
546:
547: INSERT INTO pa_expenditure_comments (
548: expenditure_item_id
549: , line_number
550: , expenditure_comment
551: , last_update_date

Line 1504: FROM pa_expenditure_comments ec

1500: /* Create comment for the reversing EI if they exist for the original EI */
1501: BEGIN
1502: SELECT ec.expenditure_comment
1503: INTO item_comment
1504: FROM pa_expenditure_comments ec
1505: WHERE ec.expenditure_item_id = TfrEiTab(i);
1506: EXCEPTION
1507: WHEN NO_DATA_FOUND THEN
1508: NULL;