DBA Data[Home] [Help]

APPS.OKC_RULE_PUB dependencies on OKC_K_LINES_B

Line 4817: from (SELECT id, level lvl from okc_k_lines_b

4813: p_ncol NUMBER
4814: ) RETURN VARCHAR2 IS
4815: CURSOR c1 IS
4816: SELECT Decode(p_ncol, 1, rul.object1_id1, 2, rul.object2_id1, NULL) retval
4817: from (SELECT id, level lvl from okc_k_lines_b
4818: start with id = p_cle_id
4819: connect by id = prior cle_id) cle,
4820: okc_rule_groups_v rgp, okc_rules_v rul
4821: where rul.rgp_id = rgp.id and rul.RULE_INFORMATION_CATEGORY=p_rule_name