DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on GL_CODE_COMBINATIONS

Line 4743: gl_code_combinations_kfv glv

4739: okl_ae_templates aet,
4740: okl_ae_tmpt_sets aes,
4741: okl_products pdt,
4742: okl_trx_types_b trx,
4743: gl_code_combinations_kfv glv
4744: WHERE aetl.avl_id = aet.id
4745: AND aet.aes_id = aes.id
4746: AND aes.id = pdt.aes_id
4747: AND pdt.id = cp_pdt_id

Line 4757: FROM gl_code_combinations

4753: -- Validate GL CCID
4754: CURSOR c_gl_ccid_valid(cp_ccid IN NUMBER,
4755: cp_bill_date IN DATE) IS
4756: SELECT 'x'
4757: FROM gl_code_combinations
4758: WHERE code_combination_id = cp_ccid
4759: AND enabled_flag = 'Y'
4760: AND cp_bill_date BETWEEN NVL(start_date_active,cp_bill_date)
4761: AND NVL(end_date_active, cp_bill_date);