DBA Data[Home] [Help]

APPS.IGC_CBC_VALIDATIONS_PKG dependencies on GL_CODE_COMBINATIONS

Line 227: FROM gl_code_combinations GCC,

223: GCC.detail_posting_allowed_flag,
224: GCC.enabled_flag,
225: GCC.start_date_active,
226: GCC.end_date_active
227: FROM gl_code_combinations GCC,
228: gl_sets_of_books GSB
229: WHERE GCC.code_combination_id = p_ccid
230: AND GSB.set_of_books_id = p_set_of_books_id
231: AND GCC.chart_of_accounts_id = GSB.chart_of_accounts_id;

Line 236: l_budget_flag gl_code_combinations.detail_budgeting_allowed_flag%TYPE;

232:
233: -- -------------------------------------------------------------------------
234: -- Declare local variables used within fuction
235: -- -------------------------------------------------------------------------
236: l_budget_flag gl_code_combinations.detail_budgeting_allowed_flag%TYPE;
237: l_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE;
238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;
239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;

Line 237: l_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE;

233: -- -------------------------------------------------------------------------
234: -- Declare local variables used within fuction
235: -- -------------------------------------------------------------------------
236: l_budget_flag gl_code_combinations.detail_budgeting_allowed_flag%TYPE;
237: l_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE;
238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;
239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;

Line 238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;

234: -- Declare local variables used within fuction
235: -- -------------------------------------------------------------------------
236: l_budget_flag gl_code_combinations.detail_budgeting_allowed_flag%TYPE;
237: l_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE;
238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;
239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;

Line 239: l_start_date gl_code_combinations.start_date_active%TYPE;

235: -- -------------------------------------------------------------------------
236: l_budget_flag gl_code_combinations.detail_budgeting_allowed_flag%TYPE;
237: l_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE;
238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;
239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;

Line 240: l_end_date gl_code_combinations.end_date_active%TYPE;

236: l_budget_flag gl_code_combinations.detail_budgeting_allowed_flag%TYPE;
237: l_posting_flag gl_code_combinations.detail_posting_allowed_flag%TYPE;
238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;
239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;
244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;