DBA Data[Home] [Help]

APPS.OKC_CLE_PVT dependencies on OKC_K_LINES_BH

Line 2898: FROM OKC_K_LINES_BH B

2894: /*
2895: DELETE FROM OKC_K_LINES_TLH T
2896: WHERE NOT EXISTS (
2897: SELECT NULL
2898: FROM OKC_K_LINES_BH B
2899: WHERE B.ID = T.ID
2900: AND T.MAJOR_VERSION = B.MAJOR_VERSION
2901: );
2902:

Line 9236: INSERT INTO okc_k_lines_bh

9232: okc_debug.Set_Indentation('OKC_CLE_PVT');
9233: okc_debug.log('23400: Entered create_version', 2);
9234: END IF;
9235:
9236: INSERT INTO okc_k_lines_bh
9237: (
9238: major_version,
9239: id,
9240: line_number,

Line 9568: FROM okc_k_lines_bh

9564: last_update_date,
9565: last_update_login
9566: FROM okc_k_lines_tlh
9567: WHERE id in (SELECT id
9568: FROM okc_k_lines_bh
9569: WHERE dnz_chr_id = p_chr_id)
9570: AND major_version = p_major_version;
9571:
9572: ------------------------------------------

Line 9775: FROM okc_k_lines_bh

9771: TERM_CANCEL_SOURCE,
9772: cancelled_amount,
9773: annualized_factor --added by npalepu 26-JUL
9774:
9775: FROM okc_k_lines_bh
9776: WHERE dnz_chr_id = p_chr_id
9777: AND major_version = p_major_version;
9778:
9779: IF (l_debug = 'Y') THEN