654: l_gl_code_combination_id NUMBER;
655: --
656: CURSOR gl_code_combination_csr (p_gl_code_combination_id IN NUMBER) IS
657: SELECT code_combination_id
658: FROM gl_code_combinations
659: WHERE code_combination_id = p_gl_code_combination_id
660: AND enabled_flag ='Y';
661: BEGIN
662: --
1022: AND p_distribution_date between date_from and nvl(pbg.DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));
1023:
1024: CURSOR gl_code_combination_csr (p_gl_code_combination_id IN NUMBER) IS
1025: SELECT code_combination_id
1026: FROM gl_code_combinations
1027: WHERE code_combination_id = p_gl_code_combination_id
1028: AND enabled_flag ='Y';
1029:
1030: CURSOR project_csr(p_project_id IN NUMBER, p_distribution_date IN DATE) IS