APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURES

Line 1487: -- These values will be inserted into PA_EXPENDITURES_ALL table

1483: , X_acct_rate_type IN VARCHAR2
1484: , X_acct_rate_date IN DATE
1485: , X_acct_exchange_rate IN NUMBER
1486: -- Trx_import enhancement: Adding new parameters
1487: -- These values will be inserted into PA_EXPENDITURES_ALL table
1488: , X_orig_exp_txn_reference1 IN VARCHAR2
1489: , X_orig_user_exp_txn_reference IN VARCHAR2
1490: , X_vendor_id IN NUMBER
1491: , X_orig_exp_txn_reference2 IN VARCHAR2

Line 1502: INSERT INTO pa_expenditures(

1498: pa_cc_utils.set_curr_function('InsertExp');
1499: IF P_DEBUG_MODE THEN
1500: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1501: END IF;
1502: INSERT INTO pa_expenditures(
1503: expenditure_id
1504: , expenditure_status_code
1505: , expenditure_ending_date
1506: , expenditure_class_code

Line 1911: , pa_expenditures e

1907: , l_ASSIGNMENT_ID
1908: /* , l_WORK_TYPE_ID bug2482593*/
1909: FROM
1910: pa_expenditure_items ei
1911: , pa_expenditures e
1912: , pa_tasks t
1913: WHERE
1914: e.expenditure_id = ei.expenditure_id
1915: AND ei.expenditure_item_id = X_source_exp_item_id