APPS.PA_RATE_PVT_PKG dependencies on PA_FORECASTING_OPTIONS_ALL

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 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