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 1516: ,okc_k_headers_b chr

1512: IS
1513: SELECT cle.orig_system_id1 orig_kle_id
1514: ,chr.orig_system_id1 orig_khr_id
1515: FROM okc_k_lines_b cle
1516: ,okc_k_headers_b chr
1517: WHERE cle.id = p_kle_id
1518: AND cle.dnz_chr_id = chr.id
1519: AND cle.orig_system_id1 IS NOT NULL;
1520:

Line 2306: From okc_K_headers_b chr

2302:
2303: Cursor khr_type_csr IS
2304: Select SCS_CODE,
2305: START_DATE
2306: From okc_K_headers_b chr
2307: Where chr.id = p_khr_id;
2308:
2309: khr_type_rec khr_type_csr%ROWTYPE;
2310: l_line_type VARCHAR2(256);

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

2310: l_line_type VARCHAR2(256);
2311:
2312: -- We here get the start date of the first SLL though there are
2313: -- more than one sll and we look for amount not null
2314: CURSOR c_rent_slls(p_khr_id okc_k_headers_b.id%TYPE,
2315: p_Kle_id okc_k_lines_b.id%TYPE,
2316: p_line_type VARCHAR2)
2317: IS
2318: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,

Line 2321: FROM okc_k_headers_b chr_so,

2317: IS
2318: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2319: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2320: khr_so.term_duration
2321: FROM okc_k_headers_b chr_so,
2322: okl_k_headers khr_so,
2323: okc_line_styles_b lse_so,
2324: okc_k_lines_b cle_so,
2325: okc_rule_groups_b rgp_pay,

Line 2350: p_khr_id okc_k_headers_b.id%TYPE,

2346: -- Since the above SLL information are broken down into
2347: -- Stream we are good enough to consider first start date of the
2348: -- SLL
2349: CURSOR c_rent_flows(p_kle_id okc_k_lines_b.id%TYPE,
2350: p_khr_id okc_k_headers_b.id%TYPE,
2351: p_line_type VARCHAR2)
2352: IS
2353: SELECT sel_amt.id se_id,
2354: sel_amt.amount se_amount,

Line 2363: okc_k_headers_b chr_so,

2359: FROM okl_streams stm,
2360: okl_strm_type_b sty,
2361: okl_strm_elements sel_amt,
2362: okl_strm_elements sel_rate,
2363: okc_k_headers_b chr_so,
2364: okc_k_lines_b cle,
2365: okc_line_styles_b lse
2366: WHERE stm.khr_id = p_khr_id
2367: AND stm.kle_id = p_kle_id

Line 2871: From okc_K_headers_b chr

2867:
2868: Cursor khr_type_csr IS
2869: Select SCS_CODE,
2870: START_DATE
2871: From okc_K_headers_b chr
2872: Where chr.id = p_khr_id;
2873:
2874: khr_type_rec khr_type_csr%ROWTYPE;
2875: l_line_type VARCHAR2(256);

Line 2896: okc_k_headers_b chr_so,

2892: FROM okl_streams stm,
2893: okl_strm_type_b sty,
2894: okl_strm_elements sel_rate,
2895: okl_strm_elements sel_amt,
2896: okc_k_headers_b chr_so,
2897: okc_k_lines_b cle,
2898: okl_k_lines kle,
2899: okc_line_styles_b lse,
2900: okc_rules_b sll,

Line 2948: okc_k_headers_b chr_so,

2944: FROM okl_streams stm,
2945: okl_strm_type_b sty,
2946: okl_strm_elements sel_rate,
2947: okl_strm_elements sel_amt,
2948: okc_k_headers_b chr_so,
2949: okc_k_lines_b cle,
2950: okl_k_lines kle,
2951: okc_line_styles_b lse,
2952: okc_rules_b sll,

Line 3000: okc_k_headers_b chr_so,

2996: FROM okl_streams stm,
2997: okl_strm_type_b sty,
2998: okl_strm_elements sel_rate,
2999: okl_strm_elements sel_amt,
3000: okc_k_headers_b chr_so,
3001: okc_k_lines_b cle,
3002: okc_line_styles_b lse,
3003: okc_rules_b sll,
3004: okc_rules_b slh,

Line 3037: FROM okc_k_headers_b chr_so,

3033: SELECT DISTINCT DECODE(rul_sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3034: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3035: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
3036: cle_so.END_DATE
3037: FROM okc_k_headers_b chr_so,
3038: okc_line_styles_b lse_so,
3039: okc_k_lines_b cle_so,
3040: okc_rule_groups_b rgp_pay,
3041: okc_rules_b rul_slh,

Line 3064: FROM okc_k_headers_b chr_so,

3060: CURSOR c_fee_cost(p_khr_id NUMBER)
3061: IS
3062: SELECT NVL(kle.amount, 0) amount,
3063: cle.start_date
3064: FROM okc_k_headers_b chr_so,
3065: okl_k_lines kle,
3066: okc_k_lines_b cle,
3067: okc_line_styles_b lse
3068: WHERE cle.chr_id = p_khr_id

Line 3112: okc_k_headers_b chr_so,

3108: FROM okl_streams stm,
3109: okl_strm_type_b sty,
3110: okl_strm_elements sel_amt,
3111: okl_strm_elements sel,
3112: okc_k_headers_b chr_so,
3113: okc_k_lines_b cle,
3114: okc_line_styles_b lse,
3115: okl_k_lines kle,
3116: okc_rules_b sll,

Line 3159: okc_k_headers_b chr_so,

3155: cle.start_date start_date
3156: FROM okc_rules_b rul,
3157: okc_rules_b rul2,
3158: okc_rule_groups_b rgp,
3159: okc_k_headers_b chr_so,
3160: okc_k_lines_b cle,
3161: okc_line_styles_b lse
3162: WHERE cle.chr_id = p_khr_id
3163: AND cle.lse_id = lse.id

Line 3185: okc_k_headers_b b

3181: CURSOR get_curr_code_pre(p_khr_id NUMBER)
3182: IS
3183: SELECT NVL(a.precision,0) precision
3184: FROM fnd_currencies a,
3185: okc_k_headers_b b
3186: WHERE b.currency_code = a.currency_code
3187: AND b.id = p_khr_id;
3188: -- To get the Contract Start date
3189: CURSOR get_start_date(p_khr_id NUMBER)

Line 3192: FROM okc_k_headers_b b

3188: -- To get the Contract Start date
3189: CURSOR get_start_date(p_khr_id NUMBER)
3190: IS
3191: SELECT start_date
3192: FROM okc_k_headers_b b
3193: WHERE b.id = p_khr_id;
3194:
3195: TYPE cash_flow_rec_type IS RECORD (cf_amount NUMBER,
3196: cf_date DATE,

Line 5118: FROM okc_k_headers_b

5114: END IF; */
5115:
5116: SELECT currency_code
5117: INTO l_currency_code
5118: FROM okc_k_headers_b
5119: WHERE id = p_khr_id;
5120:
5121: SELECT NVL(precision,0)
5122: INTO l_precision

Line 5830: FROM okc_k_headers_b chr,

5826: chr.end_date,
5827: khr.deal_type,
5828: khr.term_duration,
5829: NVL(khr.generate_accrual_yn, 'Y')
5830: FROM okc_k_headers_b chr,
5831: okl_k_headers khr
5832: WHERE khr.id = p_khr_id
5833: AND chr.id = khr.id;
5834:

Line 6306: From okc_K_headers_b chr

6302:
6303: Cursor khr_type_csr IS
6304: Select SCS_CODE,
6305: START_DATE
6306: From okc_K_headers_b chr
6307: Where chr.id = p_khr_id;
6308:
6309: khr_type_rec khr_type_csr%ROWTYPE;
6310: l_line_type VARCHAR2(256);

Line 6332: okc_k_headers_b chr_so,

6328: FROM okl_streams stm,
6329: okl_strm_type_b sty,
6330: okl_strm_elements sel_rate,
6331: okl_strm_elements sel_amt,
6332: okc_k_headers_b chr_so,
6333: okc_k_lines_b cle,
6334: okc_line_styles_b lse,
6335: okc_rules_b sll,
6336: okc_rules_b slh,

Line 6369: FROM okc_k_headers_b chr_so,

6365: SELECT DISTINCT DECODE(rul_sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
6366: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6367: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
6368: cle_so.END_DATE
6369: FROM okc_k_headers_b chr_so,
6370: okc_line_styles_b lse_so,
6371: okc_k_lines_b cle_so,
6372: okc_rule_groups_b rgp_pay,
6373: okc_rules_b rul_slh,

Line 6397: okc_k_headers_b b

6393: CURSOR get_curr_code_pre(p_khr_id NUMBER)
6394: IS
6395: SELECT NVL(a.precision,0) precision
6396: FROM fnd_currencies a,
6397: okc_k_headers_b b
6398: WHERE b.currency_code = a.currency_code
6399: AND b.id = p_khr_id;
6400:
6401: -- To get the Contract Start date

Line 6405: FROM okc_k_headers_b b

6401: -- To get the Contract Start date
6402: CURSOR get_start_date(p_khr_id NUMBER)
6403: IS
6404: SELECT start_date
6405: FROM okc_k_headers_b b
6406: WHERE b.id = p_khr_id;
6407:
6408: TYPE cash_flow_rec_type IS RECORD (cf_amount NUMBER,
6409: cf_date DATE,

Line 7033: FROM okc_k_headers_b chr,

7029: chr.end_date,
7030: khr.deal_type,
7031: khr.term_duration,
7032: NVL(khr.generate_accrual_yn, 'Y')
7033: FROM okc_k_headers_b chr,
7034: okl_k_headers khr
7035: WHERE khr.id = p_khr_id
7036: AND chr.id = khr.id;
7037:

Line 7047: FROM okc_k_headers_b chr_rv,

7043: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
7044: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
7045: cle_so.id cle_id,
7046: cle_so.start_date
7047: FROM okc_k_headers_b chr_rv,
7048: okc_line_styles_b lse_rv,
7049: okc_k_lines_b cle_rv,
7050: okc_rules_b rul_rv,
7051: okc_rule_groups_b rgp_rv,

Line 7151: FROM okc_k_headers_b chr_so,

7147: sll.rule_information10 advance_arrears,
7148: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
7149: TO_NUMBER(sll.rule_information7) stub_days,
7150: TO_NUMBER(sll.rule_information8) stub_amount
7151: FROM okc_k_headers_b chr_so,
7152: okc_k_lines_b cle,
7153: okl_k_lines kle,
7154: okc_line_styles_b lse,
7155: okc_rules_b sll,

Line 8959: FROM okc_k_headers_b

8955: END IF; */
8956:
8957: SELECT currency_code
8958: INTO l_currency_code
8959: FROM okc_k_headers_b
8960: WHERE id = p_khr_id;
8961:
8962: SELECT NVL(precision,0)
8963: INTO l_precision

Line 9542: FROM okc_k_headers_b chr,

9538: chr.end_date,
9539: khr.deal_type,
9540: khr.term_duration,
9541: NVL(khr.generate_accrual_yn, 'Y')
9542: FROM okc_k_headers_b chr,
9543: okl_k_headers khr
9544: WHERE khr.id = p_khr_id
9545: AND chr.id = khr.id;
9546:

Line 9556: FROM okc_k_headers_b chr_rv,

9552: DECODE(rul_sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
9553: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
9554: cle_so.id cle_id,
9555: cle_so.start_date
9556: FROM okc_k_headers_b chr_rv,
9557: okc_line_styles_b lse_rv,
9558: okc_k_lines_b cle_rv,
9559: okc_rules_b rul_rv,
9560: okc_rule_groups_b rgp_rv,

Line 9658: FROM okc_k_headers_b chr_so,

9654: sll.rule_information10 advance_arrears,
9655: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
9656: TO_NUMBER(sll.rule_information7) stub_days,
9657: TO_NUMBER(sll.rule_information8) stub_amount
9658: FROM okc_k_headers_b chr_so,
9659: okc_k_lines_b cle,
9660: okl_k_lines kle,
9661: okc_line_styles_b lse,
9662: okc_rules_b sll,

Line 9697: FROM okc_k_headers_b chr_so,

9693: sll.rule_information10 advance_arrears,
9694: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
9695: TO_NUMBER(sll.rule_information7) stub_days,
9696: TO_NUMBER(sll.rule_information8) stub_amount
9697: FROM okc_k_headers_b chr_so,
9698: okc_k_lines_b cle,
9699: okl_k_lines kle,
9700: okc_line_styles_b lse,
9701: okc_rules_b sll,

Line 10415: lv_currency_code okc_k_headers_b.currency_code%TYPE;

10411: l_prev_diff NUMBER :=1;
10412: l_prev_diff_sign NUMBER ;
10413: l_purpose_code VARCHAR2(30) := 'FLOW';
10414: lv_adv_arr VARCHAR2(30);
10415: lv_currency_code okc_k_headers_b.currency_code%TYPE;
10416: l_selv_tbl okl_streams_pub.selv_tbl_type;
10417: l_pt_tbl okl_streams_pub.selv_tbl_type;
10418: l_pay_level payment_tbl_type := p_pay_level;
10419: lx_pay_level payment_tbl_type;

Line 10424: l_currency_code okc_k_headers_b.currency_code%TYPE;

10420: l_cash_flow_tbl cash_flow_tbl_type;
10421: k NUMBER :=1;
10422: loop_counter BINARY_INTEGER := 0;
10423: l_open_balance NUMBER :=0;
10424: l_currency_code okc_k_headers_b.currency_code%TYPE;
10425:
10426: CURSOR c_hdr_csr(p_khr_id okc_k_headers_b.id%TYPE)
10427: IS
10428: SELECT currency_code

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

10422: loop_counter BINARY_INTEGER := 0;
10423: l_open_balance NUMBER :=0;
10424: l_currency_code okc_k_headers_b.currency_code%TYPE;
10425:
10426: CURSOR c_hdr_csr(p_khr_id okc_k_headers_b.id%TYPE)
10427: IS
10428: SELECT currency_code
10429: FROM okc_k_headers_b
10430: WHERE id = p_khr_id;

Line 10429: FROM okc_k_headers_b

10425:
10426: CURSOR c_hdr_csr(p_khr_id okc_k_headers_b.id%TYPE)
10427: IS
10428: SELECT currency_code
10429: FROM okc_k_headers_b
10430: WHERE id = p_khr_id;
10431:
10432: --Added by djanaswa for bug 6007644
10433: l_recurrence_date DATE := NULL;

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

10813: sty.stream_type_purpose
10814: ORDER BY stream_element_date,
10815: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4);
10816:
10817: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
10818: SELECT PRECISION
10819: FROM fnd_currencies_vl
10820: WHERE currency_code = p_currency_code
10821: AND enabled_flag = 'Y'