APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_K_LINES

Line 437: okl_k_lines klet,

433: klet.pay_investor_frequency,
434: klet.date_pay_investor_start,
435: klet.pay_investor_remittance_days
436: FROM okl_k_headers_full_v khr,
437: okl_k_lines klet,
438: okc_k_lines_b clet,
439: okc_line_styles_b lset
440: WHERE khr.id = p_ia_id
441: AND klet.id = clet.id

Line 456: okl_k_lines okl_fee_line ,

452: , okc_fee_line.start_date
453: , NVL(okl_fee_line.amount,0) amount
454: , okl_fee_line.fee_type
455: FROM okc_k_lines_b okc_fee_line ,
456: okl_k_lines okl_fee_line ,
457: okc_line_styles_b lse ,
458: okc_k_party_roles_b inv_line_role ,
459: okc_k_party_roles_b fee_line_role
460: WHERE inv_line_role.cle_id = p_investor_line_id

Line 951: OKL_K_LINES KLET,

947: KLET.pay_investor_frequency,
948: KLET.date_pay_investor_start,
949: KLET.pay_investor_remittance_days
950: FROM OKL_K_HEADERS_FULL_V KHR,
951: OKL_K_LINES KLET,
952: OKC_K_LINES_B CLET,
953: OKC_LINE_STYLES_B LSET
954: WHERE KHR.ID = p_ia_id
955: AND KLET.ID = CLET.ID

Line 1243: FROM OKL_K_LINES KLES,

1239: CURSOR get_parent_stake ( p_top_line_id NUMBER
1240: ,p_sty_subclass VARCHAR2 ) IS
1241: SELECT
1242: KLES.percent_stake
1243: FROM OKL_K_LINES KLES,
1244: OKC_K_LINES_B CLES,
1245: OKC_LINE_STYLES_B LSES
1246: WHERE CLES.cle_id = p_top_line_id
1247: AND KLES.stream_type_subclass = p_sty_subclass

Line 1257: l_percent_stake okl_k_lines.percent_stake%TYPE;

1253: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1254: l_ref_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
1255: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1256:
1257: l_percent_stake okl_k_lines.percent_stake%TYPE;
1258:
1259: l_parent_sty_id okl_strm_type_v.id%TYPE;
1260:
1261: l_dstr_cnt NUMBER;