eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on DUAL

Line 1643: select 'Y' from dual

1639: l_msg_index_out NUMBER;
1640: l_found varchar2(1);
1641:
1642: cursor c1 is
1643: select 'Y' from dual
1644: where exists (
1645: select 'x'
1646: from pa_summary_project_fundings fu,
1647: pa_budget_versions bv

Line 1715: select 'Y' from dual

1711: l_msg_index_out NUMBER;
1712: l_found varchar2(1);
1713:
1714: cursor c1 is
1715: select 'Y' from dual
1716: where exists (
1717: select 'x'
1718: from pa_summary_project_fundings fu,
1719: pa_budget_versions bv

Line 1827: FROM DUAL

1823: impacted_task_rec impacted_task_cur%ROWTYPE;
1824:
1825: /*CURSOR cur_impact_task_level_M_top (c_task_id pa_tasks.task_id%TYPE) IS
1826: SELECT COUNT(1)
1827: FROM DUAL
1828: WHERE EXISTS
1829: (SELECT 'X'
1830: FROM pa_resource_assignments pra
1831: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 1838: FROM DUAL

1834: AND (pra.task_id=c_task_id OR pra.task_id=p_impacted_task_id));*/
1835:
1836: CURSOR cur_impact_task_level_M_child IS
1837: SELECT COUNT(1)
1838: FROM DUAL
1839: WHERE EXISTS
1840: (SELECT 'X'
1841: FROM pa_resource_assignments pra
1842: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 1853: FROM DUAL

1849: CONNECT BY PRIOR t.parent_task_id = t.task_id));
1850:
1851: CURSOR cur_impact_task_level_L (c_top_task_id pa_tasks.task_id%TYPE) IS
1852: SELECT COUNT(1)
1853: FROM DUAL
1854: WHERE EXISTS
1855: (SELECT 'X'
1856: FROM pa_resource_assignments pra
1857: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 1865: FROM DUAL

1861:
1862:
1863: CURSOR cur_impact_task_level_T IS
1864: SELECT COUNT(1)
1865: FROM DUAL
1866: WHERE EXISTS
1867: (SELECT 'X'
1868: FROM pa_resource_assignments pra,
1869: pa_tasks t

Line 1878: FROM DUAL

1874: AND t.top_task_id = p_impacted_task_id);
1875:
1876: CURSOR cur_impacted_task_null IS
1877: SELECT count(1)
1878: FROM DUAL
1879: WHERE EXISTS
1880: (SELECT 'X'
1881: FROM pa_resource_assignments pra
1882: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 4263: FROM dual

4259:
4260: BEGIN
4261: SELECT 'Y'
4262: INTO l_return
4263: FROM dual
4264: WHERE
4265: EXISTS (SELECT 'X'
4266: FROM pa_pt_co_impl_statuses ptco,
4267: pa_ci_statuses_v pcs

Line 6101: FROM DUAL

6097: IF l_target_version_type = 'COST' OR l_target_version_type = 'ALL' THEN
6098: BEGIN
6099: SELECT 'Y'
6100: INTO l_impl_qty_exists
6101: FROM DUAL
6102: WHERE EXISTS (SELECT 1
6103: FROM PA_FP_MERGED_CTRL_ITEMS
6104: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6105: AND PLAN_VERSION_ID = p_budget_version_id

Line 6136: FROM DUAL

6132: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6133: END IF;
6134: SELECT 'Y'
6135: INTO l_impl_qty_exists
6136: FROM DUAL
6137: WHERE EXISTS (SELECT 1
6138: FROM PA_FP_MERGED_CTRL_ITEMS A
6139: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6140: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6215: FROM DUAL

6211: -- To avoid double count check for pt_ct_version_type
6212: BEGIN
6213: SELECT 'Y'
6214: INTO l_impl_qty_exists
6215: FROM DUAL
6216: WHERE EXISTS (SELECT 1
6217: FROM PA_FP_MERGED_CTRL_ITEMS
6218: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6219: AND PLAN_VERSION_ID = p_budget_version_id

Line 6248: FROM DUAL

6244: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6245: END IF;
6246: SELECT 'Y'
6247: INTO l_impl_qty_exists
6248: FROM DUAL
6249: WHERE EXISTS (SELECT 1
6250: FROM PA_FP_MERGED_CTRL_ITEMS A
6251: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6252: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6411: FROM DUAL

6407: IF l_target_version_type = 'COST' OR l_target_version_type = 'ALL' THEN
6408: BEGIN
6409: SELECT 'Y'
6410: INTO l_impl_qty_exists
6411: FROM DUAL
6412: WHERE EXISTS (SELECT 1
6413: FROM PA_FP_MERGED_CTRL_ITEMS
6414: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6415: AND PLAN_VERSION_ID = p_budget_version_id

Line 6445: FROM DUAL

6441: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6442: END IF;
6443: SELECT 'Y'
6444: INTO l_impl_qty_exists
6445: FROM DUAL
6446: WHERE EXISTS (SELECT 1
6447: FROM PA_FP_MERGED_CTRL_ITEMS A
6448: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6449: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6524: FROM DUAL

6520: -- To avoid double count check for pt_ct_version_type
6521: BEGIN
6522: SELECT 'Y'
6523: INTO l_impl_qty_exists
6524: FROM DUAL
6525: WHERE EXISTS (SELECT 1
6526: FROM PA_FP_MERGED_CTRL_ITEMS
6527: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6528: AND PLAN_VERSION_ID = p_budget_version_id

Line 6557: FROM DUAL

6553: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6554: END IF;
6555: SELECT 'Y'
6556: INTO l_impl_qty_exists
6557: FROM DUAL
6558: WHERE EXISTS (SELECT 1
6559: FROM PA_FP_MERGED_CTRL_ITEMS A
6560: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6561: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6673: FROM DUAL

6669: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6670: END IF;
6671: SELECT 'Y'
6672: INTO l_exists
6673: FROM DUAL
6674: WHERE EXISTS (SELECT 1
6675: FROM PA_FP_MERGED_CTRL_ITEMS A
6676: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6677: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6942: from dual

6938: IF l_version_type = 'ALL' or l_version_type = 'COST' THEN
6939: BEGIN
6940: Select l_cost
6941: into l_return_cost
6942: from dual
6943: where not exists (Select 1
6944: from pa_fp_merged_ctrl_items
6945: where plan_version_id = p_budget_version_id
6946: and version_type = 'COST'

Line 8519: FROM dual

8515: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8516: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8517: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8518: SELECT 'Y'
8519: FROM dual
8520: WHERE
8521: EXISTS (SELECT 'X'
8522: FROM pa_pt_co_impl_statuses popt
8523: WHERE popt.status_code =c_status_code

Line 8965: FROM DUAL

8961: IF x_partially_impl_flag = 'N' THEN
8962: BEGIN
8963: SELECT 'Y'
8964: INTO l_rev_impl_full
8965: FROM DUAL
8966: WHERE EXISTS (SELECT 1
8967: FROM PA_FP_MERGED_CTRL_ITEMS
8968: WHERE CI_PLAN_VERSION_ID = nvl(l_ci_rev_version_id,l_ci_all_version_id)
8969: AND version_type = 'REVENUE'

Line 9110: FROM DUAL

9106:
9107: BEGIN
9108: SELECT 'Y'
9109: INTO l_status_implementable
9110: FROM DUAL
9111: WHERE EXISTS (SELECT 'X'
9112: FROM pa_pt_co_impl_statuses
9113: WHERE status_code=p_status_code);
9114: EXCEPTION

Line 9175: FROM DUAL

9171: c_ci_version_id pa_budget_Versions.budget_Version_id%TYPE,
9172: c_app_cw_ver_id pa_budget_Versions.budget_Version_id%TYPE)
9173: IS
9174: SELECT 'x'
9175: FROM DUAL
9176: WHERE EXISTS (SELECT 'x'
9177: FROM pa_fp_merged_ctrl_items
9178: WHERE ci_id=p_ci_id
9179: AND plan_version_id=c_app_cw_ver_id

Line 9841: FROM DUAL

9837: l_is_merged varchar2(1) := 'N';
9838: BEGIN
9839: SELECT 'Y'
9840: INTO l_is_merged
9841: FROM DUAL
9842: WHERE EXISTS (SELECT 1
9843: FROM PA_FP_MERGED_CTRL_ITEMS
9844: WHERE CI_ID = p_ci_id);
9845:

Line 10029: FROM DUAL

10025:
10026: BEGIN
10027: SELECT 'N'
10028: INTO is_delete_allowed
10029: FROM DUAL
10030: WHERE EXISTS (SELECT 'X'
10031: FROM pa_pt_co_impl_statuses
10032: WHERE ci_type_id = p_ci_type_id);
10033: EXCEPTION