APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURES

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

1600: , X_acct_rate_type IN VARCHAR2
1601: , X_acct_rate_date IN DATE
1602: , X_acct_exchange_rate IN NUMBER
1603: -- Trx_import enhancement: Adding new parameters
1604: -- These values will be inserted into PA_EXPENDITURES_ALL table
1605: , X_orig_exp_txn_reference1 IN VARCHAR2
1606: , X_orig_user_exp_txn_reference IN VARCHAR2
1607: , X_vendor_id IN NUMBER
1608: , X_orig_exp_txn_reference2 IN VARCHAR2

Line 1619: INSERT INTO pa_expenditures(

1615: pa_cc_utils.set_curr_function('InsertExp');
1616: IF P_DEBUG_MODE THEN
1617: pa_cc_utils.log_message('InsertExp: ' || 'Start ');
1618: END IF;
1619: INSERT INTO pa_expenditures(
1620: expenditure_id
1621: , expenditure_status_code
1622: , expenditure_ending_date
1623: , expenditure_class_code

Line 2031: , pa_expenditures e

2027: /* , l_WORK_TYPE_ID bug2482593*/
2028: , l_cbs_element_id -- Added for CBS Enhancement Bug 16220146
2029: FROM
2030: pa_expenditure_items ei
2031: , pa_expenditures e
2032: , pa_tasks t
2033: WHERE
2034: e.expenditure_id = ei.expenditure_id
2035: AND ei.expenditure_item_id = X_source_exp_item_id