2433: AND internal_organization_id = c_org_id;
2434:
2435: Cursor is_ccid_valid(l_ccid number) is
2436: select 'x'
2437: from gl_code_combinations
2438: where code_combination_id = l_ccid
2439: and enabled_flag = 'Y'
2440: and p_gl_date between nvl(start_date_active,p_gl_date) and nvl(end_date_active, p_gl_date);
2441:
3228: and ledger_id = c_ledger_id;
3229:
3230: Cursor is_ccid_valid(l_ccid number) is
3231: select 'x'
3232: from gl_code_combinations
3233: where code_combination_id = l_ccid
3234: and enabled_flag = 'Y'
3235: and p_gl_date between nvl(start_date_active,p_gl_date) and nvl(end_date_active, p_gl_date);
3236:
5695: and internal_organization_id = c_internal_org_id;
5696:
5697: Cursor is_ccid_valid(l_ccid number) is
5698: select 'x'
5699: from gl_code_combinations
5700: where code_combination_id = l_ccid
5701: and enabled_flag = 'Y'
5702: and p_gl_date between nvl(start_date_active,p_gl_date) and nvl(end_date_active, p_gl_date);
5703: