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 2148: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE; /* Added for Org Forecasting */

2144:
2145: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE;
2146: l_expenditure_curr_code_burdn gl_sets_of_books.currency_code%TYPE; /* Added for Org Forecasting */
2147: l_exp_func_cst_rt_date DATE; /* Added for Org Forecasting */
2148: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE; /* Added for Org Forecasting */
2149: l_exp_func_cst_exch_rt NUMBER; /* Added for Org Forecasting */
2150: l_exp_func_raw_cost_rate NUMBER;
2151: l_exp_func_raw_cost NUMBER;
2152: l_exp_func_burdened_cost_rate NUMBER;

Line 2281: FROM gl_sets_of_books glsb, pa_implementations_all paimp

2277: IF ( p_expenditure_currency_code IS NULL) THEN
2278: BEGIN
2279: SELECT glsb.currency_code
2280: INTO l_expenditure_currency_code
2281: FROM gl_sets_of_books glsb, pa_implementations_all paimp
2282: WHERE glsb.set_of_books_id = paimp.set_of_books_id
2283: AND paimp.org_id = p_expenditure_org_id; -- bug 7413961 skkoppul: removed NVL function
2284: END;
2285: ELSE

Line 3145: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE;

3141: l_project_burdened_cost_rate NUMBER;
3142:
3143: l_exp_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
3144: l_exp_func_cst_rt_date DATE;
3145: l_exp_func_cst_rt_type PA_IMPLEMENTATIONS_ALL.default_rate_type%TYPE;
3146: l_exp_func_cst_exch_rt NUMBER;
3147:
3148: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
3149: l_txn_raw_cst_rt NUMBER;