DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on DUAL

Line 1303: FROM dual;

1299:
1300: -- Generate Run Id for Rule Import
1301: CURSOR csr_cz_run_id IS
1302: SELECT cz_xfr_run_infos_s.NEXTVAL
1303: FROM dual;
1304:
1305:
1306: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1307: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

Line 1493: FROM dual;

1489:
1490: -- Generate Run Id for Rule Import
1491: CURSOR csr_cz_run_id IS
1492: SELECT cz_xfr_run_infos_s.NEXTVAL
1493: FROM dual;
1494:
1495:
1496: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_disable';
1497: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

Line 1676: FROM dual;

1672:
1673: -- Generate Run Id for Rule Import
1674: CURSOR csr_cz_run_id IS
1675: SELECT cz_xfr_run_infos_s.NEXTVAL
1676: FROM dual;
1677:
1678:
1679: l_api_name CONSTANT VARCHAR2(30) := 'import_rule_temp_approval';
1680: l_rule_id okc_xprt_template_rules.rule_id%TYPE;