APPS.PA_ALLOC_UTILS dependencies on DUAL

Line 14: FROM dual

10: IS
11:
12: CURSOR C_resource_list_member IS
13: SELECT '1'
14: FROM dual
15: WHERE EXISTS (SELECT 'Y'
16: FROM PA_ALLOC_RESOURCES RE
17: WHERE RE.RESOURCE_LIST_MEMBER_ID=P_resource_list_member_id
18: )

Line 59: FROM dual

55: FUNCTION is_resource_list_in_rules(p_resource_list_id IN NUMBER)
56: RETURN varchar2 IS
57: CURSOR C_resource_list IS
58: SELECT '1'
59: FROM dual
60: WHERE EXISTS (SELECT 'Y'
61: FROM PA_ALLOC_RULES_ALL PAL /* Bug 4185336 Changed PA_ALLOC_RULES to PA_ALLOC_RULES_ALL */
62: WHERE PAL.BASIS_RESOURCE_LIST_ID=P_resource_list_id
63: OR PAL.ALLOC_RESOURCE_LIST_ID=P_resource_list_id

Line 104: FROM dual

100: IS
101:
102: CURSOR C_project_in_allocations is
103: SELECT '1'
104: FROM dual
105: WHERE EXISTS (SELECT 'Y'
106: FROM PA_ALLOC_TXN_DETAILS TXN
107: WHERE TXN.project_id=p_project_id)
108: OR EXISTS

Line 288: FROM dual

284: IS
285:
286: CURSOR C_task_in_targets_offsets IS
287: SELECT '1'
288: FROM dual
289: WHERE EXISTS (SELECT '1'
290: FROM PA_ALLOC_TXN_DETAILS TXN
291: WHERE TXN.task_id=p_task_id)
292: OR EXISTS

Line 307: FROM dual

303: WHERE RTGT.task_id=p_task_id);
304:
305: CURSOR C_task_in_sources IS
306: SELECT '1'
307: FROM dual
308: WHERE EXISTS (SELECT '1'
309: FROM PA_ALLOC_SOURCE_LINES SRCL
310: WHERE SRCL.task_id=p_task_id)
311: OR EXISTS

Line 380: FROM dual

376: RETURN varchar2
377: is
378: CURSOR C_budget_type_in_allocations is
379: SELECT '1'
380: FROM dual
381: WHERE EXISTS (SELECT 'Y'
382: FROM PA_ALLOC_RULES_ALL
383: WHERE basis_budget_type_code=p_budget_type_code)
384: OR EXISTS

Line 423: FROM dual

419: is
420:
421: CURSOR C_Bem_in_allocations is
422: SELECT '1'
423: FROM dual
424: WHERE EXISTS (SELECT 'Y'
425: FROM PA_ALLOC_RULES_ALL
426: WHERE basis_budget_entry_method_code=p_bem_code)
427: OR EXISTS