APPS.OKC_RULE_PUB dependencies on OKC_RG_ROLE_DEFS_V

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;