APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_RULE_GROUPS_B

Line 219: FROM okc_rule_groups_b rgp,

215: AND rate.parameter_type_code = p_parameter_type_code;
216:
217: CURSOR c_principal_pymts_yn(p_chr_id IN NUMBER) IS
218: SELECT 'Y'
219: FROM okc_rule_groups_b rgp,
220: okc_rules_b rul,
221: okl_strm_type_b sty,
222: okc_k_lines_b cle
223: WHERE rgp.rgd_code = 'LALEVL'

Line 792: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;

788: RETURN DATE IS
789:
790: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;
791: l_cle_id OKC_K_LINES_B.ID%TYPE := p_cle_id;
792: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
793:
794: l_start_date date;
795:
796: cursor KHR_CSR(P_ID IN NUMBER) is

Line 813: OKC_RULE_GROUPS_B

809:
810: cursor RGP_CSR(P_ID IN NUMBER) is
811: SELECT DNZ_CHR_ID, CLE_ID
812: FROM
813: OKC_RULE_GROUPS_B
814: WHERE
815: ID = P_ID;
816:
817: BEGIN

Line 856: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;

852: RETURN DATE
853: IS
854: l_chr_id OKC_K_HEADERS_B.ID%TYPE := NULL;
855: l_cle_id OKC_K_LINES_B.ID%TYPE := NULL;
856: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
857:
858: l_line_end_date date;
859:
860: cursor khr_csr(p_id in number) is

Line 872: from okc_rule_groups_b

868: where id = p_id;
869:
870: cursor rgp_csr(p_id in number) is
871: select dnz_chr_id, cle_id
872: from okc_rule_groups_b
873: where id = p_id;
874:
875: BEGIN
876: if(l_rgp_id is not null) then

Line 2068: okc_rule_groups_b rg

2064: FROM okc_k_lines_b cleb,
2065: okl_k_lines kleb,
2066: okc_line_styles_b lseb,
2067: okc_k_headers_b chrb,
2068: okc_rule_groups_b rg
2069: WHERE chrb.id = cleb.dnz_chr_id
2070: AND kleb.id = cleb.id
2071: AND cleb.lse_id = lseb.id
2072: AND lseb.lty_code = 'FEE'

Line 2203: okc_rule_groups_b rg

2199: FROM okc_k_lines_b cleb,
2200: okl_k_lines kleb,
2201: okc_line_styles_b lseb,
2202: okc_k_headers_b chrb,
2203: okc_rule_groups_b rg
2204: WHERE chrb.id = cleb.dnz_chr_id
2205: AND kleb.id = cleb.id
2206: AND cleb.lse_id = lseb.id
2207: AND lseb.lty_code = 'FEE'

Line 2842: *FROM OKC_RULES_B IVAR, OKC_RULES_B INTP, OKC_RULE_GROUPS_B RG, OKL_K_HEADERS K

2838:
2839: /*
2840: *CURSOR VIR_PAYMENT (P_CHR_ID IN NUMBER) IS
2841: *SELECT 'Y', K.TERM_DURATION
2842: *FROM OKC_RULES_B IVAR, OKC_RULES_B INTP, OKC_RULE_GROUPS_B RG, OKL_K_HEADERS K
2843: *WHERE
2844: *IVAR.RULE_INFORMATION_CATEGORY = 'LAIVAR' AND IVAR.RULE_INFORMATION1 = 'FLOAT' AND
2845: *INTP.RULE_INFORMATION_CATEGORY = 'LAINTP' AND INTP.RULE_INFORMATION1 = 'Y' AND
2846: *RG.ID = IVAR.RGP_ID AND RG.RGD_CODE = 'LAIIND' AND RG.ID = INTP.RGP_ID

Line 2859: OKC_RULE_GROUPS_B RG,

2855: FROM
2856: OKC_RULES_B IVAR,
2857: OKC_RULES_B INTP,
2858: OKC_RULES_B ICLC,
2859: OKC_RULE_GROUPS_B RG,
2860: OKL_K_HEADERS K
2861: WHERE
2862: IVAR.RULE_INFORMATION_CATEGORY = 'LAIVAR'
2863: AND INTP.RULE_INFORMATION_CATEGORY = 'LAINTP'

Line 3455: FROM okc_rule_groups_b rgp,

3451:
3452: CURSOR l_pymt_cle_csr(p_rgp_id IN NUMBER) IS
3453: SELECT rgp.cle_id pymt_cle_id,
3454: cleb.cle_id parent_cle_id
3455: FROM okc_rule_groups_b rgp,
3456: okc_k_lines_b cleb
3457: WHERE rgp.id = p_rgp_id
3458: AND cleb.id = rgp.cle_id;
3459:

Line 3936: FROM okc_rule_groups_b rgp,

3932: CURSOR c_all_pymts_csr(p_chr_id NUMBER) IS
3933: SELECT rgp.id rgp_lalevl_id,
3934: slh.id rul_laslh_id,
3935: rgp.cle_id
3936: FROM okc_rule_groups_b rgp,
3937: okc_rules_b slh,
3938: okc_k_lines_b cle,
3939: okc_statuses_b sts
3940: WHERE rgp.dnz_chr_id = p_chr_id

Line 3954: FROM okc_rule_groups_b rgp,

3950: p_chr_id NUMBER) IS
3951: SELECT rgp.id rgp_lalevl_id,
3952: slh.id rul_laslh_id,
3953: rgp.cle_id
3954: FROM okc_rule_groups_b rgp,
3955: okc_rules_b slh,
3956: okc_k_lines_b cle,
3957: okc_statuses_b sts
3958: WHERE rgp.dnz_chr_id = p_chr_id