[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;
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;
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
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;
3480: l_period_year,
3481: l_period_name,
3482: l_start_date,
3483: l_end_date
3484: FROM pa_implementations imp,
3485: gl_sets_of_books gl,
3486: gl_periods glper,
3487: gl_period_statuses glpersts
3488: WHERE imp.set_of_books_id = gl.set_of_books_id
3528: l_start_date,
3529: l_end_date
3530: FROM pa_periods pap,
3531: gl_period_statuses glp,
3532: pa_implementations paimp
3533: WHERE pap.gl_period_name = glp.period_name
3534: AND glp.set_of_books_id = paimp.set_of_books_id
3535: AND glp.application_id = Pa_Period_Process_Pkg.Application_id
3536: AND glp.adjustment_period_flag = 'N'
3567: glper.period_year period_yr,
3568: TO_CHAR(glper.quarter_num) period_nam,
3569: MIN(glper.start_date) start_dt,
3570: MAX(glper.end_date) end_dt
3571: FROM pa_implementations imp,
3572: gl_sets_of_books gl,
3573: gl_periods glper,
3574: gl_period_statuses glpersts,
3575: gl_date_period_map glmaps
3621: glper.period_year period_yr,
3622: TO_CHAR(glper.period_year) period_nam,
3623: MIN(glper.start_date) start_dt,
3624: MAX(glper.end_date) end_dt
3625: FROM pa_implementations imp,
3626: gl_sets_of_books gl,
3627: gl_periods glper,
3628: gl_period_statuses glpersts,
3629: gl_date_period_map glmaps