APPS.PA_CI_IMPACTS_UTIL dependencies on DUAL

Line 13: INTO l_temp from dual

9:
10:
11: BEGIN
12: SELECT 'X'
13: INTO l_temp from dual
14: WHERE exists(
15: SELECT ci_impact_id
16: FROM pa_ci_impacts
17: WHERE ci_id = p_ci_id

Line 62: INTO l_temp from dual

58:
59:
60: BEGIN
61: SELECT 'X'
62: INTO l_temp from dual
63: WHERE exists(
64: SELECT ci_impact_id
65: FROM pa_ci_impacts
66: WHERE ci_id = p_ci_id

Line 88: INTO l_temp from dual

84:
85:
86: BEGIN
87: SELECT 'X'
88: INTO l_temp from dual
89: WHERE exists(
90: SELECT ci_impact_id
91: FROM pa_ci_impacts
92: WHERE ci_id = p_ci_id

Line 111: INTO l_temp from dual

107:
108:
109: BEGIN
110: SELECT 'X'
111: INTO l_temp from dual
112: WHERE exists(
113: SELECT ci_impact_id
114: FROM pa_ci_impacts
115: WHERE ci_id = p_ci_id

Line 242: select 'N' from dual

238: AND impact_type_code = l_impact_type_code;
239:
240: CURSOR is_ok_to_copy
241: IS
242: select 'N' from dual
243: where exists
244: (
245: select ci_impact_id from pa_ci_impacts pci
246: where pci.ci_id = p_source_ci_id

Line 564: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT') from dual;

560: /*
561: CURSOR is_implement_ok
562: IS
563: SELECT
564: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CI_ALLOW_IMPACT_IMPLEMENT') from dual;
565:
566: CURSOR is_update_ok
567: IS
568: SELECT

Line 569: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE') from dual;

565:
566: CURSOR is_update_ok
567: IS
568: SELECT
569: pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM',l_status_code,'CONTROL_ITEM_ALLOW_UPDATE') from dual;
570: */
571:
572: BEGIN
573: