eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_RULES_B

Line 47: FROM okc_rules_b sll

43: p_chr_id IN NUMBER,
44: p_slh_id IN VARCHAR2)
45: IS
46: SELECT COUNT(1)
47: FROM okc_rules_b sll
48: WHERE sll.dnz_chr_id = p_chr_id
49: AND sll.rgp_id = p_rgp_id
50: AND sll.rule_information_category = 'LASLL' --| 17-Jan-06 cklee Fixed bug#4956483 |
51: AND sll.object2_id1 = p_slh_id;

Line 220: okc_rules_b rul,

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'
224: AND rgp.dnz_chr_id = p_chr_id

Line 627: FROM OKC_RULES_B RUL,

623: l_slh_id number := null;
624: cursor PAYMENT_TYPE_CSR(P_SLH_ID IN VARCHAR2) is
625: -- SELECT STRM.CODE
626: SELECT STRM.STREAM_TYPE_PURPOSE
627: FROM OKC_RULES_B RUL,
628: OKL_STRM_TYPE_B STRM
629: WHERE RUL.ID = TO_NUMBER(P_SLH_ID)
630: AND STRM.ID = TO_NUMBER(RUL.OBJECT1_ID1);
631:

Line 671: OKC_RULES_B RL

667: l_slh_id number := null;
668: cursor PAYMENT_TYPE_CSR(P_ID IN VARCHAR2) is
669: SELECT 'Y'
670: FROM OKL_STRMTYP_SOURCE_V STRM,
671: OKC_RULES_B RL
672: WHERE RL.ID = P_ID
673: AND TO_CHAR(STRM.ID1) = RL.OBJECT1_ID1
674: AND STRM.STREAM_TYPE_PURPOSE = 'UNSCHEDULED_PRINCIPAL_PAYMENT';
675:

Line 1068: FROM OKC_RULES_B SLL

1064: SELECT
1065: SLL.*,
1066: FND_DATE.canonical_to_date(nvl(SLL.RULE_INFORMATION2,null)) START_DATE,
1067: OKL_LA_PAYMENTS_PVT.get_order_sequence(SLL.RULE_INFORMATION1) SEQUENCE
1068: FROM OKC_RULES_B SLL
1069: WHERE
1070: SLL.DNZ_CHR_ID = P_CHR_ID
1071: AND SLL.RGP_ID = P_RGP_ID
1072: AND SLL.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 1722: FROM OKC_RULES_B SLH WHERE

1718:
1719: cursor SLH_CSR(P_RGP_ID IN NUMBER, P_PAYMENT_ID IN VARCHAR2) is
1720: SELECT
1721: ID
1722: FROM OKC_RULES_B SLH WHERE
1723: SLH.RGP_ID = P_RGP_ID AND
1724: -- bug 3377730.
1725: SLH.OBJECT1_ID1 = P_PAYMENT_ID;
1726: -- SLH.OBJECT1_ID1 = TO_CHAR(P_PAYMENT_ID);

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 2588: OKC_RULES_B IVAR,

2584: K.DEAL_TYPE deal_type,
2585: ICLC.RULE_INFORMATION5 calc_method,
2586: K.TERM_DURATION
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

Line 2589: OKC_RULES_B INTP,

2585: ICLC.RULE_INFORMATION5 calc_method,
2586: K.TERM_DURATION
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

Line 2590: OKC_RULES_B ICLC,

2586: K.TERM_DURATION
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'

Line 2608: l_var_method OKC_RULES_B.RULE_INFORMATION1%TYPE;

2604: AND RG.DNZ_CHR_ID = P_CHR_ID
2605: AND RG.CHR_ID = P_CHR_ID;
2606:
2607: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2608: l_var_method OKC_RULES_B.RULE_INFORMATION1%TYPE;
2609: l_calc_method OKC_RULES_B.RULE_INFORMATION5%TYPE;
2610: l_data_found BOOLEAN;
2611:
2612: /*

Line 2609: l_calc_method OKC_RULES_B.RULE_INFORMATION5%TYPE;

2605: AND RG.CHR_ID = P_CHR_ID;
2606:
2607: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2608: l_var_method OKC_RULES_B.RULE_INFORMATION1%TYPE;
2609: l_calc_method OKC_RULES_B.RULE_INFORMATION5%TYPE;
2610: l_data_found BOOLEAN;
2611:
2612: /*
2613: cursor PAYMENT_TYPE is

Line 3413: FROM OKC_RULES_B

3409: l_sts_code okc_k_headers_b.sts_code%type;
3410:
3411: CURSOR var_int_sched_counter_csr(p_id NUMBER, p_stream_id NUMBER) IS
3412: SELECT COUNT(1) counter
3413: FROM OKC_RULES_B
3414: WHERE DNZ_CHR_ID = p_id
3415: AND rule_information_category = 'LASLH'
3416: AND object1_id1 = to_char(p_stream_id);
3417:

Line 3639: okc_rules_b slh,

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
3643: AND rgp.rgd_code = 'LALEVL'

Line 3657: okc_rules_b slh,

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
3661: AND (rgp.cle_id = p_cle_id OR