APPS.PA_CC_BL_PROCESS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 123: ,p_acct_currency_code IN OUT NOCOPY pa_expenditure_items_all.acct_currency_code%TYPE

119: PROCEDURE pa_bl_pr
120: (
121: p_module_name IN VARCHAR2
122: ,p_debug_mode IN VARCHAR2
123: ,p_acct_currency_code IN OUT NOCOPY pa_expenditure_items_all.acct_currency_code%TYPE
124: ,p_acct_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.char30tabtyp
125: ,p_acct_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.char30tabtyp
126: ,p_acct_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
127: ,p_acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.char30tabtyp

Line 240: l_source_eid pa_expenditure_items_all.expenditure_item_id%TYPE;

236: l_reversal_reqd BOOLEAN;
237: l_prev_rec_exist BOOLEAN;
238: l_parent_dist_code VARCHAR2(2);
239:
240: l_source_eid pa_expenditure_items_all.expenditure_item_id%TYPE;
241: l_transfer_status_code pa_cc_dist_lines_all.transfer_status_code%TYPE;
242:
243: /*Added for cross proj*/
244: p_project_transfer_price PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2680: FROM pa_expenditure_items_all -- _ALL table used for better performance

2676: g_ei_rec(g_eicnt).upd_type := 'G';
2677:
2678: SELECT rowid
2679: INTO g_ei_rec(g_eicnt).EIRowId
2680: FROM pa_expenditure_items_all -- _ALL table used for better performance
2681: WHERE expenditure_item_id = lcur.adjusted_exp_item_id;
2682:
2683: IF P_DEBUG_MODE = 'Y' THEN
2684: log_message('update_ei: ' || '6100: Successfully got rowid of reversed EI');

Line 2857: UPDATE pa_expenditure_items_all --_All table for better performance

2853: IF g_eicnt > 0
2854: THEN
2855: FORALL i in 1..g_eicnt
2856:
2857: UPDATE pa_expenditure_items_all --_All table for better performance
2858: SET
2859: cc_rejection_code = in_cc_rejection_code(i),
2860: cc_bl_distributed_code = decode(in_cc_rejection_code(i), NULL,
2861: decode(cc_cross_charge_code, 'B', 'Y', 'X'), 'N'),