APPS.PA_RATE_PVT_PKG dependencies on PA_FORECASTING_OPTIONS

Line 175: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_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;
173: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
174:
175: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
176:
177: l_labor_schedule_fixed_date pa_projects_all.labor_schedule_fixed_date%TYPE;
178: l_labor_schedule_discount NUMBER;
179: l_labor_bill_rate_org_id NUMBER;

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 2135: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;

2131:
2132: l_x_return_status VARCHAR2(50);
2133: l_proj_bill_job_id NUMBER;
2134: l_overr_to_organization_id NUMBER;
2135: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
2136: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
2137:
2138:
2139: l_proj_cost_job_id NUMBER;

Line 2460: FROM pa_forecasting_options_all

2456: IF (p_system_linkage IS NULL ) THEN
2457: /* Added for Org_forecasting */
2458: SELECT default_assign_exp_type_class
2459: INTO l_system_linkage
2460: FROM pa_forecasting_options_all
2461: WHERE NVL(org_id,-99) = nvl(l_project_org_id,-99);
2462: ELSE
2463: l_system_linkage := p_system_linkage;
2464: END IF;

Line 2472: FROM pa_std_bill_rate_schedules_all bschal,pa_forecasting_options_all foptal

2468:
2469: IF ( p_proj_cost_job_group_id IS NULL) OR ( p_job_cost_rate_schedule_id IS NULL) THEN
2470: SELECT bschal.job_group_id,foptal.job_cost_rate_schedule_id
2471: INTO l_proj_cost_job_grp_id,l_job_cost_rate_schedule_id
2472: FROM pa_std_bill_rate_schedules_all bschal,pa_forecasting_options_all foptal
2473: WHERE bschal.bill_rate_sch_id = foptal.job_cost_rate_schedule_id
2474: /* For bug 4101595: Reverted the fix done for bug 3786192 */
2475: /* AND nvl(foptal.org_id, -99) = nvl(p_expenditure_org_id, -99) */ /* Added for 3786192 */
2476: AND bschal.org_id = l_project_org_id; -- bug 7413961 skkoppul: removed NVL function