DBA Data[Home] [Help]

APPS.OKS_USAGE_SETTLE_PUB dependencies on OKS_K_LINES_B

Line 14: FROM oks_k_lines_b rline,

10: IS
11: CURSOR line_cur (p_chr_id IN NUMBER)
12: IS
13: SELECT line.id, rline.settlement_interval, rline.usage_type,rline.usage_period, line.line_number --Bug 5284103
14: FROM oks_k_lines_b rline,
15: okc_k_lines_b line
16: WHERE line.dnz_chr_id = p_chr_id
17: AND rline.cle_id = line.id
18: AND line.lse_id = 12

Line 29: OKS_K_LINES_B rline

25: IS
26: SELECT line.id,rline.minimum_quantity,
27: line.start_date,line.end_date
28: FROM OKC_K_LINES_B line,
29: OKS_K_LINES_B rline
30: WHERE line.cle_id = p_cle_id
31: AND line.lse_id = 13
32: AND rline.cle_id = line.id;
33: