DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKC_SUBCLASSES_B

Line 76: okc_subclasses_b scsb

72: --cursor to find that chr id is valid okl contract header id
73: cursor l_chr_csr (p_chr_id in number) is
74: select 'Y'
75: from okc_k_headers_b chrb,
76: okc_subclasses_b scsb
77: where chrb.id = p_chr_id
78: and scsb.code = chrb.scs_code
79: and scsb.cls_code = 'OKL';
80:

Line 126: okc_subclasses_b scsb

122: select 'Y'
123: from okc_k_lines_b cleb,
124: okc_line_styles_b lseb,
125: okc_k_headers_b chrb,
126: okc_subclasses_b scsb
127: where chrb.id = cleb.dnz_chr_id
128: and scsb.code = chrb.scs_code
129: and scsb.cls_code = 'OKL'
130: and lseb.lty_code = nvl(p_lty_code,lseb.lty_code)