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

2062:
2063: l_x_return_status VARCHAR2(50);
2064: l_proj_bill_job_id NUMBER;
2065: l_overr_to_organization_id NUMBER;
2066: l_job_cost_rate_schedule_id pa_forecasting_options.job_cost_rate_schedule_id%TYPE;
2067: l_distribution_rule pa_projects_all.distribution_rule%TYPE;
2068:
2069:
2070: l_proj_cost_job_id NUMBER;

Line 2391: FROM pa_forecasting_options_all

2387: IF (p_system_linkage IS NULL ) THEN
2388: /* Added for Org_forecasting */
2389: SELECT default_assign_exp_type_class
2390: INTO l_system_linkage
2391: FROM pa_forecasting_options_all
2392: WHERE NVL(org_id,-99) = nvl(l_project_org_id,-99);
2393: ELSE
2394: l_system_linkage := p_system_linkage;
2395: END IF;

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