DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_CONTROL_ITEMS

Line 420: ,pa_control_items ci

416: into l_exists
417: from dual
418: where exists (select 'x'
419: from pa_budget_versions bv
420: ,pa_control_items ci
421: ,pa_ci_impacts cp
422: --For bug 3550073
423: ,pa_ci_statuses_v pcs
424: ,pa_pt_co_impl_statuses pcis

Line 1123: WHERE EXISTS ( SELECT 'X' from pa_budget_versions pb,pa_control_items pci -- added pa_control_items pci for bug 3741051

1119:
1120: SELECT 'Y'
1121: INTO l_exists
1122: FROM dual
1123: WHERE EXISTS ( SELECT 'X' from pa_budget_versions pb,pa_control_items pci -- added pa_control_items pci for bug 3741051
1124: WHERE pb.project_id = p_project_id --added the alias name for bug 3741051
1125: AND pb.fin_plan_type_id = l_fin_plan_type_id -- added the alias name for bug 3741051
1126: AND pb.version_type = l_version_type -- added the alias name for bug 3741051
1127: AND pb.project_id = pci.project_id -- added for bug 3741051