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 766: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;

762: RETURN DATE IS
763:
764: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_chr_id;
765: l_cle_id OKC_K_LINES_B.ID%TYPE := p_cle_id;
766: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
767:
768: l_start_date date;
769:
770: cursor KHR_CSR(P_ID IN NUMBER) is

Line 787: OKC_RULE_GROUPS_B

783:
784: cursor RGP_CSR(P_ID IN NUMBER) is
785: SELECT DNZ_CHR_ID, CLE_ID
786: FROM
787: OKC_RULE_GROUPS_B
788: WHERE
789: ID = P_ID;
790:
791: BEGIN

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

826: RETURN DATE
827: IS
828: l_chr_id OKC_K_HEADERS_B.ID%TYPE := NULL;
829: l_cle_id OKC_K_LINES_B.ID%TYPE := NULL;
830: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE := p_rgp_id;
831:
832: l_line_end_date date;
833:
834: cursor khr_csr(p_id in number) is

Line 846: from okc_rule_groups_b

842: where id = p_id;
843:
844: cursor rgp_csr(p_id in number) is
845: select dnz_chr_id, cle_id
846: from okc_rule_groups_b
847: where id = p_id;
848:
849: BEGIN
850: if(l_rgp_id is not null) then

Line 1861: okc_rule_groups_b rg

1857: FROM okc_k_lines_b cleb,
1858: okl_k_lines kleb,
1859: okc_line_styles_b lseb,
1860: okc_k_headers_b chrb,
1861: okc_rule_groups_b rg
1862: WHERE chrb.id = cleb.dnz_chr_id
1863: AND kleb.id = cleb.id
1864: AND cleb.lse_id = lseb.id
1865: AND lseb.lty_code = 'FEE'

Line 1992: okc_rule_groups_b rg

1988: FROM okc_k_lines_b cleb,
1989: okl_k_lines kleb,
1990: okc_line_styles_b lseb,
1991: okc_k_headers_b chrb,
1992: okc_rule_groups_b rg
1993: WHERE chrb.id = cleb.dnz_chr_id
1994: AND kleb.id = cleb.id
1995: AND cleb.lse_id = lseb.id
1996: AND lseb.lty_code = 'FEE'

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

2570:
2571: /*
2572: *CURSOR VIR_PAYMENT (P_CHR_ID IN NUMBER) IS
2573: *SELECT 'Y', K.TERM_DURATION
2574: *FROM OKC_RULES_B IVAR, OKC_RULES_B INTP, OKC_RULE_GROUPS_B RG, OKL_K_HEADERS K
2575: *WHERE
2576: *IVAR.RULE_INFORMATION_CATEGORY = 'LAIVAR' AND IVAR.RULE_INFORMATION1 = 'FLOAT' AND
2577: *INTP.RULE_INFORMATION_CATEGORY = 'LAINTP' AND INTP.RULE_INFORMATION1 = 'Y' AND
2578: *RG.ID = IVAR.RGP_ID AND RG.RGD_CODE = 'LAIIND' AND RG.ID = INTP.RGP_ID

Line 2591: OKC_RULE_GROUPS_B RG,

2587: FROM
2588: OKC_RULES_B IVAR,
2589: OKC_RULES_B INTP,
2590: OKC_RULES_B ICLC,
2591: OKC_RULE_GROUPS_B RG,
2592: OKL_K_HEADERS K
2593: WHERE
2594: IVAR.RULE_INFORMATION_CATEGORY = 'LAIVAR'
2595: AND INTP.RULE_INFORMATION_CATEGORY = 'LAINTP'

Line 3184: FROM okc_rule_groups_b rgp,

3180:
3181: CURSOR l_pymt_cle_csr(p_rgp_id IN NUMBER) IS
3182: SELECT rgp.cle_id pymt_cle_id,
3183: cleb.cle_id parent_cle_id
3184: FROM okc_rule_groups_b rgp,
3185: okc_k_lines_b cleb
3186: WHERE rgp.id = p_rgp_id
3187: AND cleb.id = rgp.cle_id;
3188:

Line 3638: FROM okc_rule_groups_b rgp,

3634: CURSOR c_all_pymts_csr(p_chr_id NUMBER) IS
3635: SELECT rgp.id rgp_lalevl_id,
3636: slh.id rul_laslh_id,
3637: rgp.cle_id
3638: FROM okc_rule_groups_b rgp,
3639: okc_rules_b slh,
3640: okc_k_lines_b cle,
3641: okc_statuses_b sts
3642: WHERE rgp.dnz_chr_id = p_chr_id

Line 3656: FROM okc_rule_groups_b rgp,

3652: p_chr_id NUMBER) IS
3653: SELECT rgp.id rgp_lalevl_id,
3654: slh.id rul_laslh_id,
3655: rgp.cle_id
3656: FROM okc_rule_groups_b rgp,
3657: okc_rules_b slh,
3658: okc_k_lines_b cle,
3659: okc_statuses_b sts
3660: WHERE rgp.dnz_chr_id = p_chr_id