[Home] [Help]
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;
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;
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;
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
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;
3618: l_period_year,
3619: l_period_name,
3620: l_start_date,
3621: l_end_date
3622: FROM pa_implementations imp,
3623: gl_sets_of_books gl,
3624: gl_periods glper,
3625: gl_period_statuses glpersts
3626: WHERE imp.set_of_books_id = gl.set_of_books_id
3666: l_start_date,
3667: l_end_date
3668: FROM pa_periods pap,
3669: gl_period_statuses glp,
3670: pa_implementations paimp
3671: WHERE pap.gl_period_name = glp.period_name
3672: AND glp.set_of_books_id = paimp.set_of_books_id
3673: AND glp.application_id = Pa_Period_Process_Pkg.Application_id
3674: AND glp.adjustment_period_flag = 'N'
3705: glper.period_year period_yr,
3706: TO_CHAR(glper.quarter_num) period_nam,
3707: MIN(glper.start_date) start_dt,
3708: MAX(glper.end_date) end_dt
3709: FROM pa_implementations imp,
3710: gl_sets_of_books gl,
3711: gl_periods glper,
3712: gl_period_statuses glpersts,
3713: gl_date_period_map glmaps
3759: glper.period_year period_yr,
3760: TO_CHAR(glper.period_year) period_nam,
3761: MIN(glper.start_date) start_dt,
3762: MAX(glper.end_date) end_dt
3763: FROM pa_implementations imp,
3764: gl_sets_of_books gl,
3765: gl_periods glper,
3766: gl_period_statuses glpersts,
3767: gl_date_period_map glmaps