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_PRICING_PVT dependencies on OKC_K_HEADERS_B

Line 30: FROM okc_k_headers_b chr_so,

26: Cursor c_rate Is
27: SELECT rte.amount rate,
28: ele.stream_element_date ele_date,
29: ele.comments
30: FROM okc_k_headers_b chr_so,
31: okc_line_styles_b lse_so,
32: okc_k_lines_b cle_so,
33: okl_strm_type_b sty,
34: okl_streams stm,

Line 91: FROM okc_k_headers_b chr_so,

87: Cursor c_rate Is
88: SELECT rte.amount rate,
89: ele.stream_element_date ele_date,
90: ele.comments
91: FROM okc_k_headers_b chr_so,
92: okc_line_styles_b lse_so,
93: okc_k_lines_b cle_so,
94: okl_strm_type_b sty,
95: okl_streams stm,

Line 2706: From okc_K_headers_b chr

2702:
2703: Cursor khr_type_csr IS
2704: Select SCS_CODE,
2705: START_DATE
2706: From okc_K_headers_b chr
2707: Where chr.id = p_khr_id;
2708:
2709: khr_type_rec khr_type_csr%ROWTYPE;
2710: l_line_type VARCHAR2(256);

Line 2714: CURSOR c_rent_slls(p_khr_id okc_k_headers_b.id%TYPE,

2710: l_line_type VARCHAR2(256);
2711:
2712: -- We here get the start date of the first SLL though there are
2713: -- more than one sll and we look for amount not null
2714: CURSOR c_rent_slls(p_khr_id okc_k_headers_b.id%TYPE,
2715: p_Kle_id okc_k_lines_b.id%TYPE,
2716: p_line_type VARCHAR2)
2717: IS
2718: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,

Line 2721: FROM okc_k_headers_b chr_so,

2717: IS
2718: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2719: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2720: khr_so.term_duration
2721: FROM okc_k_headers_b chr_so,
2722: okl_k_headers khr_so,
2723: okc_line_styles_b lse_so,
2724: okc_k_lines_b cle_so,
2725: okc_rule_groups_b rgp_pay,

Line 2750: p_khr_id okc_k_headers_b.id%TYPE,

2746: -- Since the above SLL information are broken down into
2747: -- Stream we are good enough to consider first start date of the
2748: -- SLL
2749: CURSOR c_rent_flows(p_kle_id okc_k_lines_b.id%TYPE,
2750: p_khr_id okc_k_headers_b.id%TYPE,
2751: p_line_type VARCHAR2)
2752: IS
2753: SELECT sel_amt.id se_id,
2754: sel_amt.amount se_amount,

Line 2763: okc_k_headers_b chr_so,

2759: FROM okl_streams stm,
2760: okl_strm_type_b sty,
2761: okl_strm_elements sel_amt,
2762: okl_strm_elements sel_rate,
2763: okc_k_headers_b chr_so,
2764: okc_k_lines_b cle,
2765: okc_line_styles_b lse
2766: WHERE stm.khr_id = p_khr_id
2767: AND stm.kle_id = p_kle_id

Line 3271: From okc_K_headers_b chr

3267:
3268: Cursor khr_type_csr IS
3269: Select SCS_CODE,
3270: START_DATE
3271: From okc_K_headers_b chr
3272: Where chr.id = p_khr_id;
3273:
3274: khr_type_rec khr_type_csr%ROWTYPE;
3275: l_line_type VARCHAR2(256);

Line 3296: okc_k_headers_b chr_so,

3292: FROM okl_streams stm,
3293: okl_strm_type_b sty,
3294: okl_strm_elements sel_rate,
3295: okl_strm_elements sel_amt,
3296: okc_k_headers_b chr_so,
3297: okc_k_lines_b cle,
3298: okl_k_lines kle,
3299: okc_line_styles_b lse,
3300: okc_rules_b sll,

Line 3348: okc_k_headers_b chr_so,

3344: FROM okl_streams stm,
3345: okl_strm_type_b sty,
3346: okl_strm_elements sel_rate,
3347: okl_strm_elements sel_amt,
3348: okc_k_headers_b chr_so,
3349: okc_k_lines_b cle,
3350: okl_k_lines kle,
3351: okc_line_styles_b lse,
3352: okc_rules_b sll,

Line 3400: okc_k_headers_b chr_so,

3396: FROM okl_streams stm,
3397: okl_strm_type_b sty,
3398: okl_strm_elements sel_rate,
3399: okl_strm_elements sel_amt,
3400: okc_k_headers_b chr_so,
3401: okc_k_lines_b cle,
3402: okc_line_styles_b lse,
3403: okc_rules_b sll,
3404: okc_rules_b slh,

Line 3437: FROM okc_k_headers_b chr_so,

3433: SELECT DISTINCT DECODE(rul_sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3434: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3435: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
3436: cle_so.END_DATE
3437: FROM okc_k_headers_b chr_so,
3438: okc_line_styles_b lse_so,
3439: okc_k_lines_b cle_so,
3440: okc_rule_groups_b rgp_pay,
3441: okc_rules_b rul_slh,

Line 3464: FROM okc_k_headers_b chr_so,

3460: CURSOR c_fee_cost(p_khr_id NUMBER)
3461: IS
3462: SELECT NVL(kle.amount, 0) amount,
3463: cle.start_date
3464: FROM okc_k_headers_b chr_so,
3465: okl_k_lines kle,
3466: okc_k_lines_b cle,
3467: okc_line_styles_b lse
3468: WHERE cle.chr_id = p_khr_id

Line 3512: okc_k_headers_b chr_so,

3508: FROM okl_streams stm,
3509: okl_strm_type_b sty,
3510: okl_strm_elements sel_amt,
3511: okl_strm_elements sel,
3512: okc_k_headers_b chr_so,
3513: okc_k_lines_b cle,
3514: okc_line_styles_b lse,
3515: okl_k_lines kle,
3516: okc_rules_b sll,

Line 3559: okc_k_headers_b chr_so,

3555: cle.start_date start_date
3556: FROM okc_rules_b rul,
3557: okc_rules_b rul2,
3558: okc_rule_groups_b rgp,
3559: okc_k_headers_b chr_so,
3560: okc_k_lines_b cle,
3561: okc_line_styles_b lse
3562: WHERE cle.chr_id = p_khr_id
3563: AND cle.lse_id = lse.id

Line 3585: okc_k_headers_b b

3581: CURSOR get_curr_code_pre(p_khr_id NUMBER)
3582: IS
3583: SELECT NVL(a.precision,0) precision
3584: FROM fnd_currencies a,
3585: okc_k_headers_b b
3586: WHERE b.currency_code = a.currency_code
3587: AND b.id = p_khr_id;
3588: -- To get the Contract Start date
3589: CURSOR get_start_date(p_khr_id NUMBER)

Line 3592: FROM okc_k_headers_b b

3588: -- To get the Contract Start date
3589: CURSOR get_start_date(p_khr_id NUMBER)
3590: IS
3591: SELECT start_date
3592: FROM okc_k_headers_b b
3593: WHERE b.id = p_khr_id;
3594:
3595: TYPE cash_flow_rec_type IS RECORD (cf_amount NUMBER,
3596: cf_date DATE,

Line 5508: FROM okc_k_headers_b

5504: END IF;
5505:
5506: SELECT currency_code
5507: INTO l_currency_code
5508: FROM okc_k_headers_b
5509: WHERE id = p_khr_id;
5510:
5511: SELECT NVL(precision,0)
5512: INTO l_precision

Line 6220: FROM okc_k_headers_b chr,

6216: chr.end_date,
6217: khr.deal_type,
6218: khr.term_duration,
6219: NVL(khr.generate_accrual_yn, 'Y')
6220: FROM okc_k_headers_b chr,
6221: okl_k_headers khr
6222: WHERE khr.id = p_khr_id
6223: AND chr.id = khr.id;
6224:

Line 6696: From okc_K_headers_b chr

6692:
6693: Cursor khr_type_csr IS
6694: Select SCS_CODE,
6695: START_DATE
6696: From okc_K_headers_b chr
6697: Where chr.id = p_khr_id;
6698:
6699: khr_type_rec khr_type_csr%ROWTYPE;
6700: l_line_type VARCHAR2(256);

Line 6722: okc_k_headers_b chr_so,

6718: FROM okl_streams stm,
6719: okl_strm_type_b sty,
6720: okl_strm_elements sel_rate,
6721: okl_strm_elements sel_amt,
6722: okc_k_headers_b chr_so,
6723: okc_k_lines_b cle,
6724: okc_line_styles_b lse,
6725: okc_rules_b sll,
6726: okc_rules_b slh,

Line 6759: FROM okc_k_headers_b chr_so,

6755: SELECT DISTINCT DECODE(rul_sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
6756: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6757: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
6758: cle_so.END_DATE
6759: FROM okc_k_headers_b chr_so,
6760: okc_line_styles_b lse_so,
6761: okc_k_lines_b cle_so,
6762: okc_rule_groups_b rgp_pay,
6763: okc_rules_b rul_slh,

Line 6787: okc_k_headers_b b

6783: CURSOR get_curr_code_pre(p_khr_id NUMBER)
6784: IS
6785: SELECT NVL(a.precision,0) precision
6786: FROM fnd_currencies a,
6787: okc_k_headers_b b
6788: WHERE b.currency_code = a.currency_code
6789: AND b.id = p_khr_id;
6790:
6791: -- To get the Contract Start date

Line 6795: FROM okc_k_headers_b b

6791: -- To get the Contract Start date
6792: CURSOR get_start_date(p_khr_id NUMBER)
6793: IS
6794: SELECT start_date
6795: FROM okc_k_headers_b b
6796: WHERE b.id = p_khr_id;
6797:
6798: TYPE cash_flow_rec_type IS RECORD (cf_amount NUMBER,
6799: cf_date DATE,

Line 7423: FROM okc_k_headers_b chr,

7419: chr.end_date,
7420: khr.deal_type,
7421: khr.term_duration,
7422: NVL(khr.generate_accrual_yn, 'Y')
7423: FROM okc_k_headers_b chr,
7424: okl_k_headers khr
7425: WHERE khr.id = p_khr_id
7426: AND chr.id = khr.id;
7427:

Line 7437: FROM okc_k_headers_b chr_rv,

7433: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
7434: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
7435: cle_so.id cle_id,
7436: cle_so.start_date
7437: FROM okc_k_headers_b chr_rv,
7438: okc_line_styles_b lse_rv,
7439: okc_k_lines_b cle_rv,
7440: okc_rules_b rul_rv,
7441: okc_rule_groups_b rgp_rv,

Line 7541: FROM okc_k_headers_b chr_so,

7537: sll.rule_information10 advance_arrears,
7538: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
7539: TO_NUMBER(sll.rule_information7) stub_days,
7540: TO_NUMBER(sll.rule_information8) stub_amount
7541: FROM okc_k_headers_b chr_so,
7542: okc_k_lines_b cle,
7543: okl_k_lines kle,
7544: okc_line_styles_b lse,
7545: okc_rules_b sll,

Line 9344: FROM okc_k_headers_b

9340: END IF;
9341:
9342: SELECT currency_code
9343: INTO l_currency_code
9344: FROM okc_k_headers_b
9345: WHERE id = p_khr_id;
9346:
9347: SELECT NVL(precision,0)
9348: INTO l_precision

Line 9927: FROM okc_k_headers_b chr,

9923: chr.end_date,
9924: khr.deal_type,
9925: khr.term_duration,
9926: NVL(khr.generate_accrual_yn, 'Y')
9927: FROM okc_k_headers_b chr,
9928: okl_k_headers khr
9929: WHERE khr.id = p_khr_id
9930: AND chr.id = khr.id;
9931:

Line 9941: FROM okc_k_headers_b chr_rv,

9937: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
9938: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
9939: cle_so.id cle_id,
9940: cle_so.start_date
9941: FROM okc_k_headers_b chr_rv,
9942: okc_line_styles_b lse_rv,
9943: okc_k_lines_b cle_rv,
9944: okc_rules_b rul_rv,
9945: okc_rule_groups_b rgp_rv,

Line 10043: FROM okc_k_headers_b chr_so,

10039: sll.rule_information10 advance_arrears,
10040: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10041: TO_NUMBER(sll.rule_information7) stub_days,
10042: TO_NUMBER(sll.rule_information8) stub_amount
10043: FROM okc_k_headers_b chr_so,
10044: okc_k_lines_b cle,
10045: okl_k_lines kle,
10046: okc_line_styles_b lse,
10047: okc_rules_b sll,

Line 10082: FROM okc_k_headers_b chr_so,

10078: sll.rule_information10 advance_arrears,
10079: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10080: TO_NUMBER(sll.rule_information7) stub_days,
10081: TO_NUMBER(sll.rule_information8) stub_amount
10082: FROM okc_k_headers_b chr_so,
10083: okc_k_lines_b cle,
10084: okl_k_lines kle,
10085: okc_line_styles_b lse,
10086: okc_rules_b sll,

Line 10793: lv_currency_code okc_k_headers_b.currency_code%TYPE;

10789: l_prev_diff NUMBER :=1;
10790: l_prev_diff_sign NUMBER ;
10791: l_purpose_code VARCHAR2(30) := 'FLOW';
10792: lv_adv_arr VARCHAR2(30);
10793: lv_currency_code okc_k_headers_b.currency_code%TYPE;
10794: l_selv_tbl okl_streams_pub.selv_tbl_type;
10795: l_pt_tbl okl_streams_pub.selv_tbl_type;
10796: l_pay_level payment_tbl_type := p_pay_level;
10797: lx_pay_level payment_tbl_type;

Line 10802: l_currency_code okc_k_headers_b.currency_code%TYPE;

10798: l_cash_flow_tbl cash_flow_tbl_type;
10799: k NUMBER :=1;
10800: loop_counter BINARY_INTEGER := 0;
10801: l_open_balance NUMBER :=0;
10802: l_currency_code okc_k_headers_b.currency_code%TYPE;
10803:
10804: CURSOR c_hdr_csr(p_khr_id okc_k_headers_b.id%TYPE)
10805: IS
10806: SELECT currency_code

Line 10804: CURSOR c_hdr_csr(p_khr_id okc_k_headers_b.id%TYPE)

10800: loop_counter BINARY_INTEGER := 0;
10801: l_open_balance NUMBER :=0;
10802: l_currency_code okc_k_headers_b.currency_code%TYPE;
10803:
10804: CURSOR c_hdr_csr(p_khr_id okc_k_headers_b.id%TYPE)
10805: IS
10806: SELECT currency_code
10807: FROM okc_k_headers_b
10808: WHERE id = p_khr_id;

Line 10807: FROM okc_k_headers_b

10803:
10804: CURSOR c_hdr_csr(p_khr_id okc_k_headers_b.id%TYPE)
10805: IS
10806: SELECT currency_code
10807: FROM okc_k_headers_b
10808: WHERE id = p_khr_id;
10809:
10810: --Added by djanaswa for bug 6007644
10811: l_recurrence_date DATE := NULL;

Line 11195: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS

11191: sty.stream_type_purpose
11192: ORDER BY stream_element_date,
11193: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4);
11194:
11195: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
11196: SELECT PRECISION
11197: FROM fnd_currencies_vl
11198: WHERE currency_code = p_currency_code
11199: AND enabled_flag = 'Y'