APPS.OKC_RULE_PUB dependencies on OKC_RULE_GROUPS_V

Line 4820: okc_rule_groups_v rgp, okc_rules_v rul

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
4822: and rgp.dnz_chr_id=p_chr_id
4823: and (rgp.cle_id=cle.id or rgp.cle_id IS NULL)
4824: order by decode(rgp.cle_id,NULL,1,0), lvl;

Line 4827: from okc_rule_groups_v rgp, okc_rules_v rul

4823: and (rgp.cle_id=cle.id or rgp.cle_id IS NULL)
4824: order by decode(rgp.cle_id,NULL,1,0), lvl;
4825: CURSOR c2 IS
4826: SELECT Decode(p_ncol, 1, rul.object1_id1, 2, rul.object2_id1, NULL) retval
4827: from okc_rule_groups_v rgp, okc_rules_v rul
4828: where rul.rgp_id = rgp.id and rul.RULE_INFORMATION_CATEGORY=p_rule_name
4829: and rgp.dnz_chr_id=p_chr_id and rgp.cle_id IS NULL;
4830: l_retval VARCHAR2(250);
4831: begin

Line 4854: FROM okc_rule_groups_v rgp, okc_rg_party_roles_v rpr ,okc_k_party_roles_v cpl ,OKC_RG_ROLE_DEFS_v rrd

4850: function get_object_sql(p_object_code in varchar2,p_id in number, p_rule VARCHAR2, p_ncol NUMBER) return varchar2 is
4851:
4852: CURSOR c1 IS
4853: select rgp.dnz_chr_id, rgp.cle_id, cpl.object1_id1, decode(p_rule,'BTO','BILL','STO','SHIP',NULL) rtype
4854: FROM okc_rule_groups_v rgp, okc_rg_party_roles_v rpr ,okc_k_party_roles_v cpl ,OKC_RG_ROLE_DEFS_v rrd
4855: WHERE rgp.id = p_id AND rpr.rgp_id = p_id AND rpr.cpl_id = cpl.id and rpr.rrd_id = rrd.id and subject_object_flag='O';
4856:
4857: l_party_id varchar2(40) := NULL;
4858: l_cust_acc varchar2(40) := NULL;