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 2145: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE;

2141: l_class_code pa_project_types_all.project_type_class_code%TYPE;
2142:
2143: l_schedule_type VARCHAR2(50);
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 */

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

2142:
2143: l_schedule_type VARCHAR2(50);
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;

Line 2193: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

2189: l_project_raw_cost_rate NUMBER;
2190: l_project_burdened_cost NUMBER;
2191: l_project_burdened_cost_rate NUMBER;
2192:
2193: l_cst_txn_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
2194: l_txn_raw_cst_rt NUMBER;
2195: l_txn_raw_cst NUMBER;
2196: l_txn_burdned_cst_rt NUMBER;
2197: l_txn_burdned_cst 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 3143: l_exp_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;

3139: l_project_raw_cost_rate NUMBER;
3140: l_project_burdened_cost NUMBER;
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:

Line 3148: l_cst_txn_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;
3150: l_txn_raw_cst NUMBER;
3151: l_txn_burdned_cst_rt NUMBER;
3152: l_txn_burdned_cst NUMBER;

Line 3623: gl_sets_of_books gl,

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

Line 3710: gl_sets_of_books gl,

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

Line 3764: gl_sets_of_books gl,

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