DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 1156: FROM OKC_SUBCLASS_TOP_LINE stl,

1152: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
1153: SELECT 1
1154: FROM DUAL
1155: WHERE EXISTS (SELECT 1
1156: FROM OKC_SUBCLASS_TOP_LINE stl,
1157: OKC_LINE_STYLES_V lse,
1158: OKC_K_LINES_V cle
1159: WHERE cle.id = p_top_line_id
1160: AND cle.dnz_chr_id = p_dnz_chr_id

Line 4135: FROM OKC_SUBCLASS_TOP_LINE stl,

4131: WHERE id = p_header_id;
4132:
4133: CURSOR c_old_top_line_cnt(p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
4134: SELECT COUNT(cle.id)
4135: FROM OKC_SUBCLASS_TOP_LINE stl,
4136: OKC_LINE_STYLES_V lse,
4137: OKC_K_LINES_V cle,
4138: OKC_K_HEADERS_V chrv
4139: WHERE chrv.contract_number = p_contract_number