DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on ZX_EVNT_TYP_MAPPINGS

Line 2614: ZX_EVNT_TYP_MAPPINGS

2610: BEGIN
2611:
2612: SELECT tax_event_type_code into l_event_class_rec.tax_event_type_code
2613: FROM
2614: ZX_EVNT_TYP_MAPPINGS
2615: WHERE
2616: application_id = p_sync_trx_rec.application_id
2617: AND entity_code = p_sync_trx_rec.entity_code
2618: AND event_class_code = p_sync_trx_rec.event_class_code

Line 3766: FROM ZX_EVNT_TYP_MAPPINGS

3762: IF p_transaction_line_rec.event_type_code is null THEN
3763: BEGIN
3764: SELECT event_type_code
3765: INTO l_event_type_code
3766: FROM ZX_EVNT_TYP_MAPPINGS
3767: WHERE application_id = p_transaction_line_rec.application_id
3768: AND entity_code = p_transaction_line_rec.entity_code
3769: AND event_class_code = p_transaction_line_rec.event_class_code
3770: AND tax_event_type_code = 'UPDATE';

Line 4526: ZX_EVNT_TYP_MAPPINGS zxevntmap,

4522: H.trx_id trx_id,
4523: H.quote_flag quote_flag -- Bug 5646787
4524: from
4525: ZX_TRX_HEADERS_GT h,
4526: ZX_EVNT_TYP_MAPPINGS zxevntmap,
4527: ZX_EVNT_CLS_TYPS zxevnttyp
4528: where
4529: zxevntmap.event_class_code = h.event_class_code
4530: AND zxevntmap.application_id = h.application_id

Line 5348: zx_evnt_typ_mappings evnttyp,

5344: evntcls.summarization_flag,
5345: evntcls.retain_summ_tax_line_id_flag
5346: FROM zx_rec_nrec_dist dist,
5347: zx_evnt_cls_mappings evntcls,
5348: zx_evnt_typ_mappings evnttyp,
5349: zx_tax_dist_id_gt distgt
5350: WHERE dist.application_id = evntcls.application_id
5351: AND dist.entity_code = evntcls.entity_code
5352: AND dist.event_class_code = evntcls.event_class_code

Line 6677: , ZX_EVNT_TYP_MAPPINGS zetm

6673: , zetm.event_type_code -- Bug 5598384
6674: , zect.tax_event_type_code
6675: , zect.status_code
6676: FROM ZX_TRX_HEADERS_GT zthg
6677: , ZX_EVNT_TYP_MAPPINGS zetm
6678: , ZX_EVNT_CLS_TYPS zect
6679: WHERE zthg.event_class_code = zetm.event_class_code
6680: AND zthg.entity_code = zetm.entity_code
6681: AND zthg.application_id = zetm.application_id

Line 9564: FROM ZX_EVNT_TYP_MAPPINGS zxevntmap,

9560: SELECT zxevnttyp.tax_event_type_code,
9561: zxevnttyp.status_code
9562: INTO l_event_class_rec.tax_event_type_code,
9563: l_event_class_rec.doc_status_code
9564: FROM ZX_EVNT_TYP_MAPPINGS zxevntmap,
9565: ZX_EVNT_CLS_TYPS zxevnttyp
9566: WHERE zxevntmap.event_class_code = p_hdr_det_factors_rec.event_class_code
9567: AND zxevntmap.application_id = p_hdr_det_factors_rec.application_id
9568: AND zxevntmap.entity_code = p_hdr_det_factors_rec.entity_code