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 2789: ZX_FC_TYPES_REG_ASSOC

2785: -- Create Regime Association for 'FISCAL CLASSIFICATION CODE'
2786: arp_util_tax.debug( 'Creating the regime association to fiscal type.. ');
2787:
2788: INSERT ALL INTO
2789: ZX_FC_TYPES_REG_ASSOC
2790: (Tax_regime_code,
2791: classification_type_code,
2792: effective_FROM,
2793: effective_to,

Line 2813: zx_fc_types_reg_assoc_s.nextval,

2809: SYSDATE,
2810: fnd_global.user_id,
2811: SYSDATE,
2812: FND_GLOBAL.CONC_LOGIN_ID,
2813: zx_fc_types_reg_assoc_s.nextval,
2814: 1)
2815: SELECT unique tax_regime_code
2816: FROM zx_rates_b
2817: WHERE content_owner_id in