DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on GL_CODE_COMBINATIONS

Line 2148: from gl_code_combinations

2144:
2145: -- Validate payables ccid exists.
2146: select count(*)
2147: into l_is_valid_payables_ccid
2148: from gl_code_combinations
2149: where code_combination_id = px_payables_ccid
2150: and chart_of_accounts_id = p_gl_chart_id
2151: and enabled_flag = 'Y'
2152: and summary_flag = 'N'

Line 2197: from gl_code_combinations

2193:
2194: -- Check that expense ccid exists.
2195: select count(*)
2196: into l_is_valid_expense_ccid
2197: from gl_code_combinations
2198: where code_combination_id = p_expense_ccid
2199: and chart_of_accounts_id = p_gl_chart_id
2200: and enabled_flag = 'Y'
2201: and account_type = 'E'

Line 6984: FROM gl_code_combinations gcc

6980: BEGIN
6981: query_str := 'SELECT ''Y''
6982: FROM gl_ledger_segment_values glsv
6983: WHERE glsv.segment_value in ( SELECT ' || l_bal_seg_col_name || '
6984: FROM gl_code_combinations gcc
6985: WHERE chart_of_accounts_id = :h_gl_chart_id
6986: AND code_combination_id = :h_expense_ccid
6987: AND enabled_flag = ''Y'')
6988: AND nvl(END_DATE,:h_val_date) <= :h_val_date