APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_K_LINES

Line 452: okl_k_lines klet,

448: klet.pay_investor_frequency,
449: klet.date_pay_investor_start,
450: klet.pay_investor_remittance_days
451: FROM okl_k_headers_full_v khr,
452: okl_k_lines klet,
453: okc_k_lines_b clet,
454: okc_line_styles_b lset
455: WHERE khr.id = p_ia_id
456: AND klet.id = clet.id

Line 471: okl_k_lines okl_fee_line ,

467: , okc_fee_line.start_date
468: , NVL(okl_fee_line.amount,0) amount
469: , okl_fee_line.fee_type
470: FROM okc_k_lines_b okc_fee_line ,
471: okl_k_lines okl_fee_line ,
472: okc_line_styles_b lse ,
473: okc_k_party_roles_b inv_line_role ,
474: okc_k_party_roles_b fee_line_role
475: WHERE inv_line_role.cle_id = p_investor_line_id

Line 966: OKL_K_LINES KLET,

962: KLET.pay_investor_frequency,
963: KLET.date_pay_investor_start,
964: KLET.pay_investor_remittance_days
965: FROM OKL_K_HEADERS_FULL_V KHR,
966: OKL_K_LINES KLET,
967: OKC_K_LINES_B CLET,
968: OKC_LINE_STYLES_B LSET
969: WHERE KHR.ID = p_ia_id
970: AND KLET.ID = CLET.ID

Line 1313: FROM OKL_K_LINES KLES,

1309: CURSOR get_parent_stake ( p_top_line_id NUMBER
1310: ,p_sty_subclass VARCHAR2 ) IS
1311: SELECT
1312: KLES.percent_stake
1313: FROM OKL_K_LINES KLES,
1314: OKC_K_LINES_B CLES,
1315: OKC_LINE_STYLES_B LSES
1316: WHERE CLES.cle_id = p_top_line_id
1317: AND KLES.stream_type_subclass = p_sty_subclass

Line 1327: l_percent_stake okl_k_lines.percent_stake%TYPE;

1323: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1324: l_ref_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
1325: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1326:
1327: l_percent_stake okl_k_lines.percent_stake%TYPE;
1328:
1329: l_parent_sty_id okl_strm_type_v.id%TYPE;
1330:
1331: l_dstr_cnt NUMBER;