[Home] [Help]
1089: p_event_class_rec.intrcmp_src_appln_id,
1090: p_event_class_rec.intrcmp_src_entity_code,
1091: p_event_class_rec.intrcmp_src_evnt_cls_code
1092: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1093: ZX_EVENT_CLASSES_B zxcls
1094: WHERE zxevntclsmap.event_class_code = 'INVOICE'
1095: AND zxevntclsmap.application_id = 222
1096: AND zxevntclsmap.entity_code = 'TRANSACTIONS'
1097: AND zxevntclsmap.tax_event_class_code = zxcls.tax_event_class_code ;
1194: p_event_class_rec.intrcmp_src_appln_id,
1195: p_event_class_rec.intrcmp_src_entity_code,
1196: p_event_class_rec.intrcmp_src_evnt_cls_code
1197: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1198: ZX_EVENT_CLASSES_B zxcls
1199: WHERE zxevntclsmap.entity_code = 'AP_INVOICES'
1200: AND zxevntclsmap.application_id = 200
1201: AND zxevntclsmap.event_class_code = 'STANDARD INVOICES'
1202: AND zxevntclsmap.tax_event_class_code = zxcls.tax_event_class_code ;
1442: p_event_class_rec.intrcmp_src_appln_id,
1443: p_event_class_rec.intrcmp_src_entity_code,
1444: p_event_class_rec.intrcmp_src_evnt_cls_code
1445: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap,
1446: ZX_EVENT_CLASSES_B zxcls
1447: WHERE zxevntclsmap.event_class_code = p_event_class_rec.event_class_code
1448: AND zxevntclsmap.application_id = p_event_class_rec.application_id
1449: AND zxevntclsmap.entity_code = p_event_class_rec.entity_code
1450: AND zxevntclsmap.tax_event_class_code = zxcls.tax_event_class_code ;
4672: cursor c_get_tax_evnt_cls is
4673: select TAX_EVENT_CLASS_CODE,
4674: NORMAL_SIGN_FLAG,
4675: ASC_INTRCMP_TX_EVNT_CLS_CODE
4676: from zx_event_classes_b;
4677:
4678: BEGIN
4679:
4680: FOR l_tax_evnt_cls_rec in c_get_tax_evnt_cls LOOP