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 1677: select 'Y' from dual

1673: l_msg_index_out NUMBER;
1674: l_found varchar2(1);
1675:
1676: cursor c1 is
1677: select 'Y' from dual
1678: where exists (
1679: select 'x'
1680: from pa_summary_project_fundings fu,
1681: pa_budget_versions bv

Line 1749: select 'Y' from dual

1745: l_msg_index_out NUMBER;
1746: l_found varchar2(1);
1747:
1748: cursor c1 is
1749: select 'Y' from dual
1750: where exists (
1751: select 'x'
1752: from pa_summary_project_fundings fu,
1753: pa_budget_versions bv

Line 1861: FROM DUAL

1857: impacted_task_rec impacted_task_cur%ROWTYPE;
1858:
1859: /*CURSOR cur_impact_task_level_M_top (c_task_id pa_tasks.task_id%TYPE) IS
1860: SELECT COUNT(1)
1861: FROM DUAL
1862: WHERE EXISTS
1863: (SELECT 'X'
1864: FROM pa_resource_assignments pra
1865: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 1872: FROM DUAL

1868: AND (pra.task_id=c_task_id OR pra.task_id=p_impacted_task_id));*/
1869:
1870: CURSOR cur_impact_task_level_M_child IS
1871: SELECT COUNT(1)
1872: FROM DUAL
1873: WHERE EXISTS
1874: (SELECT 'X'
1875: FROM pa_resource_assignments pra
1876: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 1887: FROM DUAL

1883: CONNECT BY PRIOR t.parent_task_id = t.task_id));
1884:
1885: CURSOR cur_impact_task_level_L (c_top_task_id pa_tasks.task_id%TYPE) IS
1886: SELECT COUNT(1)
1887: FROM DUAL
1888: WHERE EXISTS
1889: (SELECT 'X'
1890: FROM pa_resource_assignments pra
1891: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 1899: FROM DUAL

1895:
1896:
1897: CURSOR cur_impact_task_level_T IS
1898: SELECT COUNT(1)
1899: FROM DUAL
1900: WHERE EXISTS
1901: (SELECT 'X'
1902: FROM pa_resource_assignments pra,
1903: pa_tasks t

Line 1912: FROM DUAL

1908: AND t.top_task_id = p_impacted_task_id);
1909:
1910: CURSOR cur_impacted_task_null IS
1911: SELECT count(1)
1912: FROM DUAL
1913: WHERE EXISTS
1914: (SELECT 'X'
1915: FROM pa_resource_assignments pra
1916: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id

Line 4312: FROM dual

4308:
4309: BEGIN
4310: SELECT 'Y'
4311: INTO l_return
4312: FROM dual
4313: WHERE
4314: EXISTS (SELECT 'X'
4315: FROM pa_pt_co_impl_statuses ptco,
4316: pa_ci_statuses_v pcs

Line 6157: FROM DUAL

6153: IF l_target_version_type = 'COST' OR l_target_version_type = 'ALL' THEN
6154: BEGIN
6155: SELECT 'Y'
6156: INTO l_impl_qty_exists
6157: FROM DUAL
6158: WHERE EXISTS (SELECT 1
6159: FROM PA_FP_MERGED_CTRL_ITEMS
6160: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6161: AND PLAN_VERSION_ID = p_budget_version_id

Line 6192: FROM DUAL

6188: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6189: END IF;
6190: SELECT 'Y'
6191: INTO l_impl_qty_exists
6192: FROM DUAL
6193: WHERE EXISTS (SELECT 1
6194: FROM PA_FP_MERGED_CTRL_ITEMS A
6195: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6196: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6271: FROM DUAL

6267: -- To avoid double count check for pt_ct_version_type
6268: BEGIN
6269: SELECT 'Y'
6270: INTO l_impl_qty_exists
6271: FROM DUAL
6272: WHERE EXISTS (SELECT 1
6273: FROM PA_FP_MERGED_CTRL_ITEMS
6274: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6275: AND PLAN_VERSION_ID = p_budget_version_id

Line 6304: FROM DUAL

6300: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6301: END IF;
6302: SELECT 'Y'
6303: INTO l_impl_qty_exists
6304: FROM DUAL
6305: WHERE EXISTS (SELECT 1
6306: FROM PA_FP_MERGED_CTRL_ITEMS A
6307: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6308: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6467: FROM DUAL

6463: IF l_target_version_type = 'COST' OR l_target_version_type = 'ALL' THEN
6464: BEGIN
6465: SELECT 'Y'
6466: INTO l_impl_qty_exists
6467: FROM DUAL
6468: WHERE EXISTS (SELECT 1
6469: FROM PA_FP_MERGED_CTRL_ITEMS
6470: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6471: AND PLAN_VERSION_ID = p_budget_version_id

Line 6501: FROM DUAL

6497: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6498: END IF;
6499: SELECT 'Y'
6500: INTO l_impl_qty_exists
6501: FROM DUAL
6502: WHERE EXISTS (SELECT 1
6503: FROM PA_FP_MERGED_CTRL_ITEMS A
6504: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6505: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6580: FROM DUAL

6576: -- To avoid double count check for pt_ct_version_type
6577: BEGIN
6578: SELECT 'Y'
6579: INTO l_impl_qty_exists
6580: FROM DUAL
6581: WHERE EXISTS (SELECT 1
6582: FROM PA_FP_MERGED_CTRL_ITEMS
6583: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6584: AND PLAN_VERSION_ID = p_budget_version_id

Line 6613: FROM DUAL

6609: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6610: END IF;
6611: SELECT 'Y'
6612: INTO l_impl_qty_exists
6613: FROM DUAL
6614: WHERE EXISTS (SELECT 1
6615: FROM PA_FP_MERGED_CTRL_ITEMS A
6616: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6617: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 6742: FROM DUAL

6738: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
6739: END IF;
6740: SELECT 'Y'
6741: INTO l_exists
6742: FROM DUAL
6743: WHERE EXISTS (SELECT 1
6744: FROM PA_FP_MERGED_CTRL_ITEMS A
6745: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6746: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 7014: from dual

7010: IF l_version_type = 'ALL' or l_version_type = 'COST' THEN
7011: BEGIN
7012: Select l_cost
7013: into l_return_cost
7014: from dual
7015: where not exists (Select 1
7016: from pa_fp_merged_ctrl_items
7017: where plan_version_id = p_budget_version_id
7018: and version_type = 'COST'

Line 8651: FROM dual

8647: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8648: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8649: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8650: SELECT 'Y'
8651: FROM dual
8652: WHERE
8653: EXISTS (SELECT 'X'
8654: FROM pa_pt_co_impl_statuses popt
8655: WHERE popt.status_code =c_status_code

Line 9123: FROM DUAL

9119: IF x_partially_impl_flag = 'N' THEN
9120: BEGIN
9121: SELECT 'Y'
9122: INTO l_rev_impl_full
9123: FROM DUAL
9124: WHERE EXISTS (SELECT 1
9125: FROM PA_FP_MERGED_CTRL_ITEMS
9126: WHERE CI_PLAN_VERSION_ID = nvl(l_ci_rev_version_id,l_ci_all_version_id)
9127: AND version_type = 'REVENUE'

Line 9268: FROM DUAL

9264:
9265: BEGIN
9266: SELECT 'Y'
9267: INTO l_status_implementable
9268: FROM DUAL
9269: WHERE EXISTS (SELECT 'X'
9270: FROM pa_pt_co_impl_statuses
9271: WHERE status_code=p_status_code);
9272: EXCEPTION

Line 9333: FROM DUAL

9329: c_ci_version_id pa_budget_Versions.budget_Version_id%TYPE,
9330: c_app_cw_ver_id pa_budget_Versions.budget_Version_id%TYPE)
9331: IS
9332: SELECT 'x'
9333: FROM DUAL
9334: WHERE EXISTS (SELECT 'x'
9335: FROM pa_fp_merged_ctrl_items
9336: WHERE ci_id=p_ci_id
9337: AND plan_version_id=c_app_cw_ver_id

Line 10000: FROM DUAL

9996: l_is_editplanned_enabled varchar2(1) := 'N';
9997: BEGIN
9998: SELECT 'Y'
9999: INTO l_is_editplanned_enabled
10000: FROM DUAL
10001: WHERE EXISTS (SELECT 1
10002: FROM PA_CI_TYPES_V
10003: WHERE CI_TYPE_ID = (SELECT CI_TYPE_ID FROM PA_CONTROL_ITEMS WHERE CI_ID = p_ci_id)
10004: AND (IMPACT_BUDGET_TYPE_CODE = 'EDIT_PLANNED_AMOUNTS' OR

Line 10025: FROM DUAL

10021: l_is_merged varchar2(1) := 'N';
10022: BEGIN
10023: SELECT 'Y'
10024: INTO l_is_merged
10025: FROM DUAL
10026: WHERE EXISTS (SELECT 1
10027: FROM PA_FP_MERGED_CTRL_ITEMS
10028: WHERE CI_ID = p_ci_id);
10029:

Line 10213: FROM DUAL

10209:
10210: BEGIN
10211: SELECT 'N'
10212: INTO is_delete_allowed
10213: FROM DUAL
10214: WHERE EXISTS (SELECT 'X'
10215: FROM pa_pt_co_impl_statuses
10216: WHERE ci_type_id = p_ci_type_id);
10217: EXCEPTION