APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKC_RULE_GROUPS_B

Line 656: FROM okc_rule_groups_b

652: object1_id2
653: FROM okc_rules_b
654: WHERE rgp_id =
655: (SELECT id
656: FROM okc_rule_groups_b
657: WHERE dnz_chr_id = p_khr_id
658: AND cle_id IS NULL
659: AND rgd_code = 'LABILL')
660: AND rule_information_category = p_rule_category;

Line 668: FROM Okc_rule_groups_B

664: /*CURSOR bto_csr( p_khr_id NUMBER, p_rule_category VARCHAR2 ) IS
665: SELECT Jtot_object1_code, Jtot_object2_code, object1_id1
666: FROM OKC_RULES_B
667: WHERE Rgp_id = (SELECT id
668: FROM Okc_rule_groups_B
669: WHERE dnz_chr_id = p_khr_id AND cle_id IS NULL
670: AND rgd_code = 'LABILL') AND
671: rule_information_category = p_rule_category;*/
672:

Line 705: AND EXISTS (SELECT '1' FROM okc_rule_groups_b rgp

701: CURSOR cust_id_csr(p_khr_id NUMBER) IS
702: SELECT object1_id1
703: FROM okc_rules_b rul
704: WHERE rul.rule_information_category = 'CAN'
705: AND EXISTS (SELECT '1' FROM okc_rule_groups_b rgp
706: WHERE rgp.id = rul.rgp_id
707: AND rgp.rgd_code = 'LACAN'
708: AND rgp.chr_id = rul.dnz_chr_id
709: AND rgp.chr_id = p_khr_id);

Line 814: Okc_rule_groups_B rgp

810: -- Tax Cursor for Exempt Or Standard
811: CURSOR astx_csr ( p_khr_id NUMBER ) IS
812: SELECT rule_information1
813: FROM OKC_RULES_B rul,
814: Okc_rule_groups_B rgp
815: WHERE rul.rgp_id = rgp.id AND
816: rgp.rgd_code = 'LAASTX' AND
817: rgp.dnz_chr_id = rgp.chr_id AND
818: rul.rule_information_category = 'LAASTX' AND

Line 825: Okc_rule_groups_B rgp

821: -- Tax Cursor for Exempt Or Standard at Line level
822: CURSOR astx_line_csr ( p_khr_id NUMBER, p_cle_id NUMBER ) IS
823: SELECT rule_information1
824: FROM OKC_RULES_B rul,
825: Okc_rule_groups_B rgp
826: WHERE rul.rgp_id = rgp.id AND
827: rgp.rgd_code = 'LAASTX' AND
828: rgp.cle_id = p_cle_id AND
829: rul.rule_information_category = 'LAASTX' AND

Line 916: FROM okc_rule_groups_b a,

912: -- AR. Bug 4525643
913: -- -------------------------------------------
914: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
915: SELECT rule_information1 private_label
916: FROM okc_rule_groups_b a,
917: okc_rules_b b
918: WHERE a.dnz_chr_id = cp_khr_id
919: AND a.rgd_code = 'LALABL'
920: AND a.id = b.rgp_id