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 653: FROM OKC_RULES_B RUL,

649: l_slh_id number := null;
650: cursor PAYMENT_TYPE_CSR(P_SLH_ID IN VARCHAR2) is
651: -- SELECT STRM.CODE
652: SELECT STRM.STREAM_TYPE_PURPOSE
653: FROM OKC_RULES_B RUL,
654: OKL_STRM_TYPE_B STRM
655: WHERE RUL.ID = TO_NUMBER(P_SLH_ID)
656: AND STRM.ID = TO_NUMBER(RUL.OBJECT1_ID1);
657:

Line 697: OKC_RULES_B RL

693: l_slh_id number := null;
694: cursor PAYMENT_TYPE_CSR(P_ID IN VARCHAR2) is
695: SELECT 'Y'
696: FROM OKL_STRMTYP_SOURCE_V STRM,
697: OKC_RULES_B RL
698: WHERE RL.ID = P_ID
699: AND TO_CHAR(STRM.ID1) = RL.OBJECT1_ID1
700: AND STRM.STREAM_TYPE_PURPOSE = 'UNSCHEDULED_PRINCIPAL_PAYMENT';
701:

Line 1096: FROM OKC_RULES_B SLL

1092: SELECT
1093: SLL.*,
1094: FND_DATE.canonical_to_date(nvl(SLL.RULE_INFORMATION2,null)) START_DATE,
1095: OKL_LA_PAYMENTS_PVT.get_order_sequence(SLL.RULE_INFORMATION1) SEQUENCE
1096: FROM OKC_RULES_B SLL
1097: WHERE
1098: SLL.DNZ_CHR_ID = P_CHR_ID
1099: AND SLL.RGP_ID = P_RGP_ID
1100: AND SLL.RULE_INFORMATION_CATEGORY = 'LASLL'

Line 1121: l_structure OKC_RULES_B.rule_information5%TYPE := structure;

1117: l_contract_end_date DATE; --Bug#5441811
1118: l_line_end_date DATE; -- Bug 6152538
1119:
1120: --Added by bkatraga for bug 13478101
1121: l_structure OKC_RULES_B.rule_information5%TYPE := structure;
1122: l_frequency OKC_RULES_B.object1_id1%TYPE := frequency;
1123: l_arrears OKC_RULES_B.rule_information10%TYPE := 'Y';
1124: l_stub_rulv_rec OKL_RULE_PUB.rulv_rec_type;
1125: lx_stub_rulv_rec OKL_RULE_PUB.rulv_rec_type;

Line 1122: l_frequency OKC_RULES_B.object1_id1%TYPE := frequency;

1118: l_line_end_date DATE; -- Bug 6152538
1119:
1120: --Added by bkatraga for bug 13478101
1121: l_structure OKC_RULES_B.rule_information5%TYPE := structure;
1122: l_frequency OKC_RULES_B.object1_id1%TYPE := frequency;
1123: l_arrears OKC_RULES_B.rule_information10%TYPE := 'Y';
1124: l_stub_rulv_rec OKL_RULE_PUB.rulv_rec_type;
1125: lx_stub_rulv_rec OKL_RULE_PUB.rulv_rec_type;
1126: --end bkatraga

Line 1123: l_arrears OKC_RULES_B.rule_information10%TYPE := 'Y';

1119:
1120: --Added by bkatraga for bug 13478101
1121: l_structure OKC_RULES_B.rule_information5%TYPE := structure;
1122: l_frequency OKC_RULES_B.object1_id1%TYPE := frequency;
1123: l_arrears OKC_RULES_B.rule_information10%TYPE := 'Y';
1124: l_stub_rulv_rec OKL_RULE_PUB.rulv_rec_type;
1125: lx_stub_rulv_rec OKL_RULE_PUB.rulv_rec_type;
1126: --end bkatraga
1127:

Line 1929: FROM OKC_RULES_B SLH WHERE

1925:
1926: cursor SLH_CSR(P_RGP_ID IN NUMBER, P_PAYMENT_ID IN VARCHAR2) is
1927: SELECT
1928: ID
1929: FROM OKC_RULES_B SLH WHERE
1930: SLH.RGP_ID = P_RGP_ID AND
1931: -- bug 3377730.
1932: SLH.OBJECT1_ID1 = P_PAYMENT_ID;
1933: -- SLH.OBJECT1_ID1 = TO_CHAR(P_PAYMENT_ID);

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

2852: K.DEAL_TYPE deal_type,
2853: ICLC.RULE_INFORMATION5 calc_method,
2854: K.TERM_DURATION
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

Line 2857: OKC_RULES_B INTP,

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

Line 2858: OKC_RULES_B ICLC,

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

Line 2876: l_var_method OKC_RULES_B.RULE_INFORMATION1%TYPE;

2872: AND RG.DNZ_CHR_ID = P_CHR_ID
2873: AND RG.CHR_ID = P_CHR_ID;
2874:
2875: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2876: l_var_method OKC_RULES_B.RULE_INFORMATION1%TYPE;
2877: l_calc_method OKC_RULES_B.RULE_INFORMATION5%TYPE;
2878: l_data_found BOOLEAN;
2879:
2880: /*

Line 2877: l_calc_method OKC_RULES_B.RULE_INFORMATION5%TYPE;

2873: AND RG.CHR_ID = P_CHR_ID;
2874:
2875: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
2876: l_var_method OKC_RULES_B.RULE_INFORMATION1%TYPE;
2877: l_calc_method OKC_RULES_B.RULE_INFORMATION5%TYPE;
2878: l_data_found BOOLEAN;
2879:
2880: /*
2881: cursor PAYMENT_TYPE is

Line 3711: FROM OKC_RULES_B

3707: l_sts_code okc_k_headers_b.sts_code%type;
3708:
3709: CURSOR var_int_sched_counter_csr(p_id NUMBER, p_stream_id NUMBER) IS
3710: SELECT COUNT(1) counter
3711: FROM OKC_RULES_B
3712: WHERE DNZ_CHR_ID = p_id
3713: AND rule_information_category = 'LASLH'
3714: AND object1_id1 = to_char(p_stream_id);
3715:

Line 3937: okc_rules_b slh,

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

Line 3955: okc_rules_b slh,

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