DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKC_K_LINES_B

Line 453: okc_k_lines_b clet,

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

Line 470: FROM okc_k_lines_b okc_fee_line ,

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

Line 967: OKC_K_LINES_B CLET,

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

Line 1314: OKC_K_LINES_B CLES,

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