APPS.CSR_RULES_PVT dependencies on DUAL

Line 600: SELECT csr_rule_windows_tl_s.NEXTVAL INTO l_window_id FROM dual;

596: l_windows_id_list.extend;
597: l_windows_id_list(i):=l_window_id;
598: IF l_window_id < 0 THEN
599:
600: SELECT csr_rule_windows_tl_s.NEXTVAL INTO l_window_id FROM dual;
601: l_windows_id_list(i):=l_window_id;
602:
603: INSERT INTO csr_rule_windows_tl (
604: window_id

Line 1457: UNION ALL SELECT -9999, 9999999 FROM DUAL

1453: FROM csr_rules_vl r
1454: , (SELECT terr_id, LEVEL terr_level FROM jtf_terr_all
1455: START WITH terr_id = :terr_id
1456: CONNECT BY NOCYCLE PRIOR parent_territory_id = terr_id
1457: UNION ALL SELECT -9999, 9999999 FROM DUAL
1458: ) t
1459: WHERE r.appl_id IN (:appl_id, -9999)
1460: AND r.resp_id IN (:resp_id, -9999)
1461: AND r.user_id IN (:user_id, -9999)