DBA Data[Home] [Help]

APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on GL_CODE_COMBINATIONS

Line 6919: l_account_seg_value gl_code_combinations.segment1%TYPE;

6915: (p_tax_determine_date <= zxt.effective_to OR zxt.effective_to IS NULL))
6916: ORDER BY zxt.compounding_precedence;
6917:
6918: l_app_column_name fnd_id_flex_segments.application_column_name%TYPE;
6919: l_account_seg_value gl_code_combinations.segment1%TYPE;
6920: l_delimiter varchar2(5) := NULL;
6921: l_num_result NUMBER;
6922: l_boolean_result BOOLEAN;
6923: l_flexsegtab fnd_flex_ext.SegmentArray;

Line 7006: -- Get the column name of the account segment in GL_CODE_COMBINATIONS

7002: END IF;
7003:
7004: IF l_account_ccid IS NOT NULL AND l_account_ccid <> -1 THEN
7005:
7006: -- Get the column name of the account segment in GL_CODE_COMBINATIONS
7007: --
7008: IF (g_level_statement >= g_current_runtime_level ) THEN
7009: FND_LOG.STRING(g_level_statement,
7010: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',

Line 7026: ' FROM gl_code_combinations cc ' ||

7022:
7023: -- bug#8226639- use bind variable for l_account_ccid
7024:
7025: l_sql_statement := 'SELECT ' || l_app_column_name ||
7026: ' FROM gl_code_combinations cc ' ||
7027: ' WHERE cc.code_combination_id = :l_account_ccid ';
7028:
7029: EXECUTE IMMEDIATE l_sql_statement INTO l_account_seg_value
7030: USING l_account_ccid;