APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKC_RULES_B

Line 644: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;

640: AND rle_code = 'CUSTOMER'
641: AND chr_id = p_khr_id
642: and dnz_chr_id = chr_id ;
643:
644: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
645: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
646: l_object1_id1 okc_rules_b.object1_id1%TYPE;
647: l_object1_id2 okc_rules_b.object1_id2%TYPE;
648:

Line 645: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;

641: AND chr_id = p_khr_id
642: and dnz_chr_id = chr_id ;
643:
644: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
645: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
646: l_object1_id1 okc_rules_b.object1_id1%TYPE;
647: l_object1_id2 okc_rules_b.object1_id2%TYPE;
648:
649: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS

Line 646: l_object1_id1 okc_rules_b.object1_id1%TYPE;

642: and dnz_chr_id = chr_id ;
643:
644: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
645: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
646: l_object1_id1 okc_rules_b.object1_id1%TYPE;
647: l_object1_id2 okc_rules_b.object1_id2%TYPE;
648:
649: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
650: SELECT jtot_object1_code,

Line 647: l_object1_id2 okc_rules_b.object1_id2%TYPE;

643:
644: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
645: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
646: l_object1_id1 okc_rules_b.object1_id1%TYPE;
647: l_object1_id2 okc_rules_b.object1_id2%TYPE;
648:
649: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
650: SELECT jtot_object1_code,
651: object1_id1,

Line 653: FROM okc_rules_b

649: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
650: SELECT jtot_object1_code,
651: object1_id1,
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

Line 666: FROM OKC_RULES_B

662: --commented out for rules migration
663:
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

Line 703: FROM okc_rules_b rul

699:
700: /*commented out for rules migration on 21-Aug-2003
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'

Line 813: FROM OKC_RULES_B rul,

809: /* 5162232 Start
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

Line 824: FROM OKC_RULES_B rul,

820:
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

Line 832: l_asst_tax OKC_RULES_B.rule_information1%TYPE;

828: rgp.cle_id = p_cle_id AND
829: rul.rule_information_category = 'LAASTX' AND
830: rgp.dnz_chr_id = p_khr_id;
831:
832: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
833: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
834:
835: 5162232 End */ -- Performance Improvement
836: l_max_commit NUMBER := 500;

Line 833: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;

829: rul.rule_information_category = 'LAASTX' AND
830: rgp.dnz_chr_id = p_khr_id;
831:
832: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
833: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
834:
835: 5162232 End */ -- Performance Improvement
836: l_max_commit NUMBER := 500;
837: --l_commit_cnt NUMBER;

Line 917: okc_rules_b b

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
921: AND b.rule_information_category = 'LALOGO';

Line 923: l_private_label okc_rules_b.rule_information1%TYPE;

919: AND a.rgd_code = 'LALABL'
920: AND a.id = b.rgp_id
921: AND b.rule_information_category = 'LALOGO';
922:
923: l_private_label okc_rules_b.rule_information1%TYPE;
924:
925: -- to get inventory_org_id bug 4890024 begin
926: CURSOR inv_org_id_csr(p_contract_id NUMBER) IS
927: SELECT NVL(inv_organization_id, -99)