DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKC_K_LINES_B

Line 438: okc_k_lines_b clet,

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
442: AND khr.id = clet.dnz_chr_id

Line 455: FROM okc_k_lines_b okc_fee_line ,

451: SELECT okc_fee_line.id
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

Line 952: OKC_K_LINES_B CLET,

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
956: AND KHR.ID = CLET.DNZ_CHR_ID

Line 1244: OKC_K_LINES_B CLES,

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
1248: AND KLES.ID = CLES.ID