APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_EXT_AP_HEADER_SOURCES_B

Line 6519: FROM okl_ext_ap_header_sources_b hdr

6515: -- Cursor to fetch header_extension_id
6516: CURSOR c_header_extension_id_csr (p_header_source_id NUMBER, p_khr_id NUMBER)
6517: IS
6518: SELECT hdr.header_extension_id header_extension_id
6519: FROM okl_ext_ap_header_sources_b hdr
6520: WHERE hdr.source_id = p_header_source_id
6521: AND hdr.khr_id = p_khr_id;
6522: -- Cursor to fetch trans number
6523: CURSOR c_trans_number_csr (p_header_source_id NUMBER)

Line 7427: FROM okl_ext_ap_header_sources_b pxh

7423: -- Cursor Definitions
7424: CURSOR get_ap_ext_hdr_id( p_source_id NUMBER, p_source_table VARCHAR2)
7425: IS
7426: SELECT pxh.header_extension_id header_extension_id
7427: FROM okl_ext_ap_header_sources_b pxh
7428: WHERE pxh.source_id = p_source_id
7429: AND pxh.source_table = p_source_table;
7430:
7431: CURSOR get_ap_ext_lns_id( p_hdr_ext_id NUMBER)

Line 7502: -- Note that for a given Source ID and Source Table in OKL_EXT_AP_HEADER_SOURCES_B

7498: FOR t_rec IN get_ap_ext_hdr_id(
7499: p_source_id => l_pxhv_rec.source_id
7500: ,p_source_table => l_pxhv_rec.source_table)
7501: LOOP
7502: -- Note that for a given Source ID and Source Table in OKL_EXT_AP_HEADER_SOURCES_B
7503: -- there can be multiple records each having different KHR_ID ..
7504: l_pxhv_rec.header_extension_id := t_rec.header_extension_id;
7505: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7506: 'Extension Header ID To be Deleted=' || TO_CHAR(l_pxhv_rec.header_extension_id));