eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RATE_PVT_PKG dependencies on GL_SETS_OF_BOOKS

Line 204: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE;

200: l_new_rcvr_revenue NUMBER;
201:
202: l_class_code pa_project_types_all.project_type_class_code%TYPE;
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 */

Line 205: l_expenditure_curr_code_burdn gl_sets_of_books.currency_code%TYPE; /* Added for Org Forecasting */

201:
202: l_class_code pa_project_types_all.project_type_class_code%TYPE;
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;

Line 252: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

248: l_project_raw_cost_rate NUMBER;
249: l_project_burdened_cost NUMBER;
250: l_project_burdened_cost_rate NUMBER;
251:
252: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
253: l_txn_raw_cst_rt NUMBER;
254: l_txn_raw_cst NUMBER;
255: l_txn_burdned_cst_rt NUMBER;
256: l_txn_burdned_cst 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 2076: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE;

2072: l_class_code pa_project_types_all.project_type_class_code%TYPE;
2073:
2074: l_schedule_type VARCHAR2(50);
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 */

Line 2077: l_expenditure_curr_code_burdn gl_sets_of_books.currency_code%TYPE; /* Added for Org Forecasting */

2073:
2074: l_schedule_type VARCHAR2(50);
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;

Line 2124: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

2120: l_project_raw_cost_rate NUMBER;
2121: l_project_burdened_cost NUMBER;
2122: l_project_burdened_cost_rate NUMBER;
2123:
2124: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
2125: l_txn_raw_cst_rt NUMBER;
2126: l_txn_raw_cst NUMBER;
2127: l_txn_burdned_cst_rt NUMBER;
2128: l_txn_burdned_cst 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 3013: l_exp_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

3009: l_project_raw_cost_rate NUMBER;
3010: l_project_burdened_cost NUMBER;
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:

Line 3018: l_cst_txn_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;
3020: l_txn_raw_cst NUMBER;
3021: l_txn_burdned_cst_rt NUMBER;
3022: l_txn_burdned_cst NUMBER;

Line 3485: gl_sets_of_books gl,

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
3489: AND gl.period_set_name = glper.period_set_name

Line 3572: gl_sets_of_books gl,

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
3576: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 3626: gl_sets_of_books gl,

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
3630: WHERE imp.set_of_books_id = gl.set_of_books_id