DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKC_LINE_STYLES_B

Line 439: okc_line_styles_b lset

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
443: AND clet.lse_id = lset.id

Line 457: okc_line_styles_b lse ,

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
461: AND inv_line_role.dnz_chr_id = p_ia_id

Line 953: OKC_LINE_STYLES_B LSET

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
957: AND CLET.LSE_ID = LSET.ID

Line 1245: OKC_LINE_STYLES_B LSES

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
1249: AND CLES.LSE_ID = LSES.ID