DBA Data[Home] [Help]

APPS.ZX_GL_TAX_OPTIONS_PKG dependencies on ZX_SCO_TAXES

Line 116: AND exists ( select 1 from zx_sco_taxes taxes

112: AND acr.ledger_id = p_ledger_id
113: AND acr.account_segment_value = p_account_segment
114: AND p_trx_date >= rates.effective_from and
115: (p_trx_date <= rates.effective_to OR rates.effective_to IS NULL)
116: AND exists ( select 1 from zx_sco_taxes taxes
117: where taxes.tax_regime_code = rates.tax_regime_code
118: AND taxes.tax = rates.tax
119: AND taxes.live_for_applicability_flag = 'Y'
120: AND taxes.live_for_processing_flag = 'Y'

Line 145: AND exists ( select 1 from zx_sco_taxes taxes

141: AND acr.ledger_id = p_ledger_id
142: AND acr.account_segment_value IS NULL
143: AND p_trx_date >= rates.effective_from and
144: (p_trx_date <= rates.effective_to OR rates.effective_to IS NULL)
145: AND exists ( select 1 from zx_sco_taxes taxes
146: where taxes.tax_regime_code = rates.tax_regime_code
147: AND taxes.tax = rates.tax
148: AND taxes.live_for_applicability_flag = 'Y'
149: AND taxes.live_for_processing_flag = 'Y'