DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_K_LINES_FULL_V

Line 51: from okl_k_lines_full_v kle,

47: CURSOR top_svc_csr ( chrId NUMBER, linkId NUMBER ) IS
48: select to_char(kle1.id) top_svc_id,
49: kle1.amount top_amount,
50: kle.amount link_amount
51: from okl_k_lines_full_v kle,
52: okl_k_lines_full_v kle1,
53: okc_line_styles_b lse,
54: okc_statuses_b sts
55: where KLE1.LSE_ID = LSE.ID

Line 52: okl_k_lines_full_v kle1,

48: select to_char(kle1.id) top_svc_id,
49: kle1.amount top_amount,
50: kle.amount link_amount
51: from okl_k_lines_full_v kle,
52: okl_k_lines_full_v kle1,
53: okc_line_styles_b lse,
54: okc_statuses_b sts
55: where KLE1.LSE_ID = LSE.ID
56: and ((lse.lty_code = 'SOLD_SERVICE') OR (lse.lty_code = 'FEE'and kle1.fee_type ='PASSTHROUGH')) -- linked fees on passthrus.