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 284: FROM dual

280: IS
281:
282: CURSOR C_task_in_targets_offsets IS
283: SELECT '1'
284: FROM dual
285: WHERE EXISTS (SELECT '1'
286: FROM PA_ALLOC_TXN_DETAILS TXN
287: WHERE TXN.task_id=p_task_id)
288: OR EXISTS

Line 303: FROM dual

299: WHERE RTGT.task_id=p_task_id);
300:
301: CURSOR C_task_in_sources IS
302: SELECT '1'
303: FROM dual
304: WHERE EXISTS (SELECT '1'
305: FROM PA_ALLOC_SOURCE_LINES SRCL
306: WHERE SRCL.task_id=p_task_id)
307: OR EXISTS

Line 367: FROM dual

363: RETURN varchar2
364: is
365: CURSOR C_budget_type_in_allocations is
366: SELECT '1'
367: FROM dual
368: WHERE EXISTS (SELECT 'Y'
369: FROM PA_ALLOC_RULES_ALL
370: WHERE basis_budget_type_code=p_budget_type_code)
371: OR EXISTS

Line 410: FROM dual

406: is
407:
408: CURSOR C_Bem_in_allocations is
409: SELECT '1'
410: FROM dual
411: WHERE EXISTS (SELECT 'Y'
412: FROM PA_ALLOC_RULES_ALL
413: WHERE basis_budget_entry_method_code=p_bem_code)
414: OR EXISTS