APPS.OKL_CONS_BILL dependencies on OKC_K_LINES_B

Line 1003: l_chr_id okc_k_lines_b.chr_id%TYPE;

999: l_update_tbl update_tbl_type;
1000:
1001: l_kle_id NUMBER;
1002: l_top_kle_id NUMBER;
1003: l_chr_id okc_k_lines_b.chr_id%TYPE;
1004: l_asset_name okc_k_lines_v.name%TYPE;
1005:
1006: CURSOR check_top_line ( p_cle_id NUMBER ) IS
1007: SELECT chr_id

Line 1008: FROM okc_k_lines_b

1004: l_asset_name okc_k_lines_v.name%TYPE;
1005:
1006: CURSOR check_top_line ( p_cle_id NUMBER ) IS
1007: SELECT chr_id
1008: FROM okc_k_lines_b
1009: WHERE id = p_cle_id;
1010:
1011: CURSOR top_line_asset ( p_cle_id NUMBER ) IS
1012: SELECT name

Line 1019: OKC_K_LINES_B TOP_CLE,

1015:
1016: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
1017: SELECT FA.ID
1018: FROM OKC_K_HEADERS_B CHR,
1019: OKC_K_LINES_B TOP_CLE,
1020: OKC_LINE_STYLES_b TOP_LSE,
1021: OKC_K_LINES_B SUB_CLE,
1022: OKC_LINE_STYLES_b SUB_LSE,
1023: OKC_K_ITEMS CIM,

Line 1021: OKC_K_LINES_B SUB_CLE,

1017: SELECT FA.ID
1018: FROM OKC_K_HEADERS_B CHR,
1019: OKC_K_LINES_B TOP_CLE,
1020: OKC_LINE_STYLES_b TOP_LSE,
1021: OKC_K_LINES_B SUB_CLE,
1022: OKC_LINE_STYLES_b SUB_LSE,
1023: OKC_K_ITEMS CIM,
1024: OKC_K_LINES_V FA,
1025: OKC_LINE_STYLES_B AST_LSE,

Line 1923: OKC_K_LINES_B TOP_CLE,

1919:
1920: CURSOR service_asset_csr (p_lsm_id NUMBER) IS
1921: SELECT FA.NAME
1922: FROM OKC_K_HEADERS_B CHR,
1923: OKC_K_LINES_B TOP_CLE,
1924: OKC_LINE_STYLES_b TOP_LSE,
1925: OKC_K_LINES_B SUB_CLE,
1926: OKC_LINE_STYLES_b SUB_LSE,
1927: OKC_K_ITEMS CIM,

Line 1925: OKC_K_LINES_B SUB_CLE,

1921: SELECT FA.NAME
1922: FROM OKC_K_HEADERS_B CHR,
1923: OKC_K_LINES_B TOP_CLE,
1924: OKC_LINE_STYLES_b TOP_LSE,
1925: OKC_K_LINES_B SUB_CLE,
1926: OKC_LINE_STYLES_b SUB_LSE,
1927: OKC_K_ITEMS CIM,
1928: OKC_K_LINES_V FA,
1929: OKC_LINE_STYLES_B AST_LSE,