APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on GL_CODE_COMBINATIONS

Line 2609: FROM gl_code_combinations

2605: AND internal_organization_id = c_org_id;
2606:
2607: CURSOR is_ccid_valid(l_ccid NUMBER) IS
2608: SELECT 'x'
2609: FROM gl_code_combinations
2610: WHERE code_combination_id = l_ccid
2611: AND enabled_flag = 'Y'
2612: AND p_gl_date BETWEEN NVL(start_date_active,p_gl_date)
2613: AND NVL(end_date_active, p_gl_date);

Line 2633: FROM gl_code_combinations_kfv

2629: WHERE set_of_books_id = c_sob_id;
2630:
2631: CURSOR get_account_string (l_ccid NUMBER) IS
2632: SELECT SUBSTRB(concatenated_segments,1,250) account_string
2633: FROM gl_code_combinations_kfv
2634: WHERE code_combination_id = l_ccid;
2635:
2636: l_source_rate_code VARCHAR2(30);
2637: l_rate_code VARCHAR2(30);

Line 3422: from gl_code_combinations

3418: and ledger_id = c_ledger_id;
3419:
3420: Cursor is_ccid_valid(l_ccid number) is
3421: select 'x'
3422: from gl_code_combinations
3423: where code_combination_id = l_ccid
3424: and enabled_flag = 'Y'
3425: and p_gl_date between nvl(start_date_active,p_gl_date) and nvl(end_date_active, p_gl_date);
3426:

Line 5985: from gl_code_combinations

5981: and internal_organization_id = c_internal_org_id;
5982:
5983: Cursor is_ccid_valid(l_ccid number) is
5984: select 'x'
5985: from gl_code_combinations
5986: where code_combination_id = l_ccid
5987: and enabled_flag = 'Y'
5988: and p_gl_date between nvl(start_date_active,p_gl_date) and nvl(end_date_active, p_gl_date);
5989: