APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_FC_CODES_CATEG_ASSOC

Line 202: from zx_fc_codes_categ_assoc

198:
199: /*
200: Cursor c_trxbizcat_fiscalclass is
201: select 'ALLOCATED',effective_from, effective_to
202: from zx_fc_codes_categ_assoc
203: where classification_type_code = NVL(FcType.OWNER_ID_CHAR,p_fsc_rec.classification_type)
204: and FcType
205: and Classification_Code_Concat = p_fsc_rec.condition_value
206: and trans_business_categ_type_code = 'TRX_BUSINESS_CATEGORY'

Line 213: from zx_fc_codes_categ_assoc assoc,

209: */
210:
211: Cursor c_trxbizcat_fiscalclass is
212: select 'ALLOCATED',assoc.effective_from, assoc.effective_to
213: from zx_fc_codes_categ_assoc assoc,
214: zx_fc_types_b fctypes,
215: zx_fc_codes_denorm_b denorm
216: where assoc.classification_type_code = nvl(fctypes.owner_id_char,p_fsc_rec.classification_type)
217: and fctypes.classification_type_code = p_fsc_rec.classification_type

Line 231: from zx_fc_codes_categ_assoc

227: -- Traverse to check for association to higher levels on Trx Biz Category
228: /*
229: Cursor c_parent_trxbizcat_fiscalclass is
230: select 'ALLOCATED',effective_from, effective_to
231: from zx_fc_codes_categ_assoc
232: where classification_type_code = p_fsc_rec.classification_type
233: and Classification_Code_Concat = p_fsc_rec.condition_value
234: and trans_business_categ_type_code = 'TRX_BUSINESS_CATEGORY'
235: and instr(p_fsc_rec.event_class_code,Trans_Business_Categ_Concat) <> 0

Line 241: from zx_fc_codes_categ_assoc assoc,

237: */
238:
239: Cursor c_parent_trxbizcat_fiscalclass is
240: select 'ALLOCATED',assoc.effective_from, assoc.effective_to
241: from zx_fc_codes_categ_assoc assoc,
242: zx_fc_types_b fctypes,
243: zx_fc_codes_denorm_b denorm
244: where assoc.classification_type_code = nvl(fctypes.owner_id_char,p_fsc_rec.classification_type)
245: and fctypes.classification_type_code = p_fsc_rec.classification_type