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 PA_PROJECT_TYPES_ALL

Line 167: l_project_type pa_project_types_all.project_type%TYPE;

163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
165:
166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
167: l_project_type pa_project_types_all.project_type%TYPE;
168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
169: l_project_org_id pa_projects_all.org_id%TYPE;
170: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
171: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

Line 202: l_class_code pa_project_types_all.project_type_class_code%TYPE;

198: l_new_rcvr_acct_raw_cost_rate NUMBER;
199: l_new_rcvr_acct_bur_cost_rate NUMBER;
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 */

Line 306: FROM pa_project_types_all typ, pa_projects_all proj

302: */
303: BEGIN
304: SELECT proj.distribution_rule,typ.project_type_class_code
305: INTO l_distribution_rule,l_class_code
306: FROM pa_project_types_all typ, pa_projects_all proj
307: WHERE proj.project_id = p_project_id
308: AND proj.project_type = typ.project_type
309: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
310:

Line 534: FROM pa_project_types_all typ, pa_projects_all proj

530: IF ( p_project_type IS NULL) THEN
531:
532: SELECT typ.project_type
533: INTO l_project_type
534: FROM pa_project_types_all typ, pa_projects_all proj
535: WHERE proj.project_id = p_project_id
536: AND proj.project_type = typ.project_type
537: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul: removed NVL function
538:

Line 1882: l_class_code pa_project_types_all.project_type_class_code%TYPE;

1878: l_proj_typ VARCHAR2(1); -- Used to store type of the project for return
1879: -- statement i.e. if 'T' - 'T and M' ,'C' - 'Cost based'
1880: -- and if 'E' - ' Event based'
1881:
1882: l_class_code pa_project_types_all.project_type_class_code%TYPE;
1883: l_no_rule EXCEPTION;
1884:
1885: BEGIN
1886:

Line 1897: FROM pa_project_types_all typ, pa_projects_all proj

1893: /* Selecting distribution rule for checking wheather the project is Fixed Price or T and M */
1894: BEGIN
1895: SELECT proj.distribution_rule,typ.project_type_class_code
1896: INTO l_rule,l_class_code
1897: FROM pa_project_types_all typ, pa_projects_all proj
1898: WHERE proj.project_id = p_project_id
1899: AND proj.project_type = typ.project_type
1900: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
1901:

Line 2045: l_project_type pa_project_types_all.project_type%TYPE;

2041: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
2042:
2043:
2044:
2045: l_project_type pa_project_types_all.project_type%TYPE;
2046: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2047:
2048: l_project_org_id pa_projects_all.org_id%TYPE;
2049: l_project_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

Line 2072: l_class_code pa_project_types_all.project_type_class_code%TYPE;

2068:
2069:
2070: l_proj_cost_job_id NUMBER;
2071: l_cost_rate_multiplier NUMBER;
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;

Line 2189: FROM pa_project_types_all typ, pa_projects_all proj

2185: /* Selecting distribution rule for calculation rate */
2186: BEGIN
2187: SELECT proj.distribution_rule,typ.project_type_class_code,proj.labor_sch_type
2188: INTO l_distribution_rule,l_class_code,l_labor_schedule_type
2189: FROM pa_project_types_all typ, pa_projects_all proj
2190: WHERE proj.project_id = p_project_id
2191: AND proj.project_type = typ.project_type
2192: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul : removed NVL function
2193:

Line 2239: FROM pa_project_types_all typ, pa_projects_all proj

2235: IF ( p_project_type IS NULL) THEN
2236:
2237: SELECT typ.project_type
2238: INTO l_project_type
2239: FROM pa_project_types_all typ, pa_projects_all proj
2240: WHERE proj.project_id = p_project_id
2241: AND proj.project_type = typ.project_type
2242: AND proj.org_id = typ.org_id; -- bug 7413961 skkoppul: removed NVL function
2243: