APPS.AHL_APPROVALS_PVT dependencies on DUAL

Line 471: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

467: l_and_operating_clause VARCHAR2(100) := ' AND operating_unit_id IS NULL';
468:
469: BEGIN
470:
471: l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
472: bind_parse (p_where_clause, l_bind_tbl);
473: --
474: -- Support up to 6 WHERE conditions for uniqueness. If
475: -- the number of conditions changes, then must also revise

Line 588: FROM dual;

584: l_seed VARCHAR2(1) := 'N';
585:
586: CURSOR c_seq IS
587: SELECT Ahl_Approval_Rules_B_S.NEXTVAL
588: FROM dual;
589:
590: CURSOR c_id_exists (x_id IN NUMBER) IS
591: SELECT 1
592: FROM dual

Line 592: FROM dual

588: FROM dual;
589:
590: CURSOR c_id_exists (x_id IN NUMBER) IS
591: SELECT 1
592: FROM dual
593: WHERE EXISTS (SELECT 1
594: FROM Ahl_Approval_Rules_vl
595: WHERE Approval_Rule_id = x_id);
596: CURSOR c_operating IS

Line 2365: FROM dual;

2361: l_object_version_number NUMBER := 1;
2362:
2363: CURSOR c_seq IS
2364: SELECT Ahl_Approvers_S.NEXTVAL
2365: FROM dual;
2366:
2367: CURSOR c_id_exists (x_id IN NUMBER) IS
2368: SELECT 1
2369: FROM dual

Line 2369: FROM dual

2365: FROM dual;
2366:
2367: CURSOR c_id_exists (x_id IN NUMBER) IS
2368: SELECT 1
2369: FROM dual
2370: WHERE EXISTS (SELECT 1
2371: FROM AHL_Approvers
2372: WHERE Approval_Approver_Id = x_id);
2373: BEGIN