APPS.OKC_RULE_PUB dependencies on OKC_K_PARTY_ROLES_V

Line 4765: SELECT object1_id1 from okc_k_party_roles_v

4761: end get_object_sql;
4762:
4763: function get_object_sql(p_object_code in varchar2,p_cpl_id in number) return varchar2 is
4764: CURSOR c1 IS
4765: SELECT object1_id1 from okc_k_party_roles_v
4766: where id = p_cpl_id;
4767: l1 varchar2(40);
4768:
4769: CURSOR l_csr IS

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;