APPS.OKS_BILL_MIGRATION dependencies on OKC_RULE_GROUPS_B

Line 513: ,OKC_RULE_GROUPS_B rgp

509: ,rul.jtot_object1_code ConvTypeCode
510: ,con.NAME ConvType
511: From OKX_CONVERSION_TYPES_V con
512: ,OKC_RULES_B rul
513: ,OKC_RULE_GROUPS_B rgp
514: Where rgp.DNZ_CHR_ID = p_dnz_chr_id
515: and rul.Rgp_Id = rgp.Id
516: and rul.RULE_INFORMATION_CATEGORY = 'CVN'
517: and con.ID1 = rul.OBJECT1_ID1;

Line 696: FROM okc_k_lines_b lines,okc_rule_groups_b rgp

692: SELECT lines.id,lines.lse_id lse_id,lines.cle_id,lines.dnz_chr_id,
693: lines.start_date,NVL(lines.date_terminated,lines.end_date) end_date,
694: lines.date_terminated,
695: rgp.id rgp_id
696: FROM okc_k_lines_b lines,okc_rule_groups_b rgp
697: WHERE lines.dnz_chr_id = rgp.dnz_chr_id
698: AND lines.id = rgp.cle_id
699: AND lines.lse_id IN (1,12,19)
700: and lines.id = p_cle_id;

Line 1421: okc_rule_groups_b rgp,

1417: SELECT lines.id id,lines.lse_id lse_id,lines.cle_id cle_id,lines.dnz_chr_id,
1418: lines.start_date start_date,NVL(lines.date_terminated,lines.end_date) end_date,
1419: lines.date_terminated date_terminated, rgp.id rgp_id, rul.object1_id1 inv_rul_id
1420: FROM okc_k_lines_b lines,
1421: okc_rule_groups_b rgp,
1422: okc_rules_b rul
1423: WHERE lines.id = rgp.cle_id
1424: AND lines.lse_id in (1,12,19)
1425: AND lines.sts_code not in ('TERMINATED','ENTERED','CANCELLED')