DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 207: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE; /* Added for Org Forecasting */

203:
204: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE;
205: l_expenditure_curr_code_burdn gl_sets_of_books.currency_code%TYPE; /* Added for Org Forecasting */
206: l_exp_func_cst_rt_date DATE; /* Added for Org Forecasting */
207: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE; /* Added for Org Forecasting */
208: l_exp_func_cst_exch_rt NUMBER; /* Added for Org Forecasting */
209: l_exp_func_raw_cost_rate NUMBER;
210: l_exp_func_raw_cost NUMBER;
211: l_exp_func_burdened_cost_rate NUMBER;

Line 493: FROM gl_sets_of_books glsb, pa_implementations_all paimp

489: only if the passed value is null otherwise storing passed values */
490: IF ( p_expenditure_currency_code IS NULL) THEN
491: SELECT glsb.currency_code
492: INTO l_expenditure_currency_code
493: FROM gl_sets_of_books glsb, pa_implementations_all paimp
494: WHERE glsb.set_of_books_id = paimp.set_of_books_id
495: AND paimp.org_id = l_expenditure_org_id; -- bug 7413961 skkoppul: removed NVL function
496: ELSE
497: l_expenditure_currency_code := p_expenditure_currency_code;

Line 2079: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE; /* Added for Org Forecasting */

2075:
2076: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE;
2077: l_expenditure_curr_code_burdn gl_sets_of_books.currency_code%TYPE; /* Added for Org Forecasting */
2078: l_exp_func_cst_rt_date DATE; /* Added for Org Forecasting */
2079: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE; /* Added for Org Forecasting */
2080: l_exp_func_cst_exch_rt NUMBER; /* Added for Org Forecasting */
2081: l_exp_func_raw_cost_rate NUMBER;
2082: l_exp_func_raw_cost NUMBER;
2083: l_exp_func_burdened_cost_rate NUMBER;

Line 2212: FROM gl_sets_of_books glsb, pa_implementations_all paimp

2208: IF ( p_expenditure_currency_code IS NULL) THEN
2209: BEGIN
2210: SELECT glsb.currency_code
2211: INTO l_expenditure_currency_code
2212: FROM gl_sets_of_books glsb, pa_implementations_all paimp
2213: WHERE glsb.set_of_books_id = paimp.set_of_books_id
2214: AND paimp.org_id = p_expenditure_org_id; -- bug 7413961 skkoppul: removed NVL function
2215: END;
2216: ELSE

Line 3015: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE;

3011: l_project_burdened_cost_rate NUMBER;
3012:
3013: l_exp_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
3014: l_exp_func_cst_rt_date DATE;
3015: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE;
3016: l_exp_func_cst_exch_rt NUMBER;
3017:
3018: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
3019: l_txn_raw_cst_rt NUMBER;