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