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_STD_BILL_RATE_SCHEDULES_ALL

Line 168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_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;
172: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

Line 711: FROM pa_std_bill_rate_schedules_all bschal,pa_forecasting_options_all foptal

707:
708: IF ( p_proj_cost_job_group_id IS NULL) OR ( p_job_cost_rate_schedule_id IS NULL) THEN
709: SELECT bschal.job_group_id,foptal.job_cost_rate_schedule_id
710: INTO l_proj_cost_job_grp_id,l_job_cost_rate_schedule_id
711: FROM pa_std_bill_rate_schedules_all bschal,pa_forecasting_options_all foptal
712: WHERE bschal.bill_rate_sch_id = foptal.job_cost_rate_schedule_id
713: /* For Bug 4101595: Reverted the fix done for 3786192 */
714: /* AND nvl(foptal.org_id, -99) = nvl(l_expenditure_org_id, -99) */ /* Added for 3786192 */
715: AND foptal.org_id = l_project_org_id; -- bug 7413961 skkoppul: removed NVL function, changed bschal.org_id to foptal.org_id

Line 2046: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%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;
2050: l_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

Line 2403: FROM pa_std_bill_rate_schedules_all bschal,pa_forecasting_options_all foptal

2399:
2400: IF ( p_proj_cost_job_group_id IS NULL) OR ( p_job_cost_rate_schedule_id IS NULL) THEN
2401: SELECT bschal.job_group_id,foptal.job_cost_rate_schedule_id
2402: INTO l_proj_cost_job_grp_id,l_job_cost_rate_schedule_id
2403: FROM pa_std_bill_rate_schedules_all bschal,pa_forecasting_options_all foptal
2404: WHERE bschal.bill_rate_sch_id = foptal.job_cost_rate_schedule_id
2405: /* For bug 4101595: Reverted the fix done for bug 3786192 */
2406: /* AND nvl(foptal.org_id, -99) = nvl(p_expenditure_org_id, -99) */ /* Added for 3786192 */
2407: AND bschal.org_id = l_project_org_id; -- bug 7413961 skkoppul: removed NVL function