DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_FC_TYPES_REG_ASSOC

Line 68: from zx_fc_types_reg_assoc

64:
65: -- Validate if Fiscal Type has been associated to regime
66: cursor c_regime_assoc is
67: select 'Y'
68: from zx_fc_types_reg_assoc
69: where classification_type_code = p_fsc_rec.classification_type
70: and tax_regime_code = p_fsc_rec.tax_regime_code;
71:
72: -- Check also for regimes above.

Line 75: from zx_fc_types_reg_assoc

71:
72: -- Check also for regimes above.
73: cursor c_parent_regime_assoc is
74: select unique 'Y'
75: from zx_fc_types_reg_assoc
76: where classification_type_code = p_fsc_rec.classification_type
77: and tax_regime_code IN (
78: select regime_code
79: from zx_regime_relations

Line 2722: ZX_FC_TYPES_REG_ASSOC

2718: -- Create Regime Association for 'FISCAL CLASSIFICATION CODE'
2719: arp_util_tax.debug( 'Creating the regime association to fiscal type.. ');
2720:
2721: INSERT ALL INTO
2722: ZX_FC_TYPES_REG_ASSOC
2723: (Tax_regime_code,
2724: classification_type_code,
2725: effective_FROM,
2726: effective_to,

Line 2746: zx_fc_types_reg_assoc_s.nextval,

2742: SYSDATE,
2743: fnd_global.user_id,
2744: SYSDATE,
2745: FND_GLOBAL.CONC_LOGIN_ID,
2746: zx_fc_types_reg_assoc_s.nextval,
2747: 1)
2748: SELECT unique tax_regime_code
2749: FROM zx_rates_b
2750: WHERE content_owner_id in