APPS.OKS_BILL_MIGRATION dependencies on OKC_RULES_B

Line 512: ,OKC_RULES_B rul

508: ,rul.rule_information3 EuroRate
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'

Line 725: FROM okc_rules_b a

721: a.rule_information5,a.rule_information6,
722: a.rule_information7,a.rule_information8,
723: a.created_by,a.creation_date,a.last_updated_by,a.last_update_date,
724: a.last_update_login
725: FROM okc_rules_b a
726: WHERE a.rule_information_category = 'SBG'
727: AND a.rgp_id = p_rgp_id;
728:
729:

Line 1422: okc_rules_b rul

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')
1426: and lines.dnz_chr_id = rgp.dnz_chr_id

Line 1490: FROM okc_rules_b a

1486: a.rule_information5,a.rule_information6,
1487: a.rule_information7,a.rule_information8,
1488: a.created_by,a.creation_date,a.last_updated_by,a.last_update_date,
1489: a.last_update_login
1490: FROM okc_rules_b a
1491: WHERE a.rule_information_category = 'SBG'
1492: AND a.rgp_id = p_rgp_id;
1493:
1494: