APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on DUAL

Line 1317: FROM dual;

1313:
1314: -- Generate Run Id for Rule Import
1315: CURSOR csr_cz_run_id IS
1316: SELECT cz_xfr_run_infos_s.NEXTVAL
1317: FROM dual;
1318:
1319:
1320: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1321: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

Line 1507: FROM dual;

1503:
1504: -- Generate Run Id for Rule Import
1505: CURSOR csr_cz_run_id IS
1506: SELECT cz_xfr_run_infos_s.NEXTVAL
1507: FROM dual;
1508:
1509:
1510: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_disable';
1511: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

Line 1690: FROM dual;

1686:
1687: -- Generate Run Id for Rule Import
1688: CURSOR csr_cz_run_id IS
1689: SELECT cz_xfr_run_infos_s.NEXTVAL
1690: FROM dual;
1691:
1692:
1693: l_api_name CONSTANT VARCHAR2(30) := 'import_rule_temp_approval';
1694: l_rule_id okc_xprt_template_rules.rule_id%TYPE;