DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on ZX_EVNT_TYP_MAPPINGS

Line 3092: ZX_EVNT_TYP_MAPPINGS

3088: BEGIN
3089:
3090: SELECT tax_event_type_code into l_event_class_rec.tax_event_type_code
3091: FROM
3092: ZX_EVNT_TYP_MAPPINGS
3093: WHERE
3094: application_id = p_sync_trx_rec.application_id
3095: AND entity_code = p_sync_trx_rec.entity_code
3096: AND event_class_code = p_sync_trx_rec.event_class_code

Line 4413: FROM ZX_EVNT_TYP_MAPPINGS

4409: IF p_transaction_line_rec.event_type_code is null THEN
4410: BEGIN
4411: SELECT event_type_code
4412: INTO l_event_type_code
4413: FROM ZX_EVNT_TYP_MAPPINGS
4414: WHERE application_id = p_transaction_line_rec.application_id
4415: AND entity_code = p_transaction_line_rec.entity_code
4416: AND event_class_code = p_transaction_line_rec.event_class_code
4417: AND tax_event_type_code = 'UPDATE';

Line 5168: zx_evnt_typ_mappings zetm,

5164: hdr.entity_code entity_code,
5165: hdr.event_class_code event_class_code,
5166: hdr.trx_id trx_id
5167: FROM zx_trx_headers_gt hdr,
5168: zx_evnt_typ_mappings zetm,
5169: zx_evnt_cls_typs zect
5170: WHERE zetm.event_class_code = hdr.event_class_code
5171: AND zetm.application_id = hdr.application_id
5172: AND zetm.entity_code = hdr.entity_code

Line 6306: zx_evnt_typ_mappings evnttyp,

6302: evntcls.summarization_flag,
6303: evntcls.retain_summ_tax_line_id_flag
6304: FROM zx_rec_nrec_dist dist,
6305: zx_evnt_cls_mappings evntcls,
6306: zx_evnt_typ_mappings evnttyp,
6307: zx_tax_dist_id_gt distgt
6308: WHERE dist.application_id = evntcls.application_id
6309: AND dist.entity_code = evntcls.entity_code
6310: AND dist.event_class_code = evntcls.event_class_code

Line 7142: FROM zx_evnt_typ_mappings

7138:
7139: BEGIN
7140: SELECT tax_event_type_code
7141: INTO l_event_class_rec.tax_event_type_code
7142: FROM zx_evnt_typ_mappings
7143: WHERE application_id = p_transaction_rec.application_id
7144: AND entity_code = p_transaction_rec.entity_code
7145: AND event_class_code = p_transaction_rec.event_class_code
7146: AND event_type_code = p_transaction_rec.event_type_code;

Line 7736: , ZX_EVNT_TYP_MAPPINGS zetm

7732: , zetm.event_type_code -- Bug 5598384
7733: , zect.tax_event_type_code
7734: , zect.status_code
7735: FROM ZX_TRX_HEADERS_GT zthg
7736: , ZX_EVNT_TYP_MAPPINGS zetm
7737: , ZX_EVNT_CLS_TYPS zect
7738: WHERE zthg.event_class_code = zetm.event_class_code
7739: AND zthg.entity_code = zetm.entity_code
7740: AND zthg.application_id = zetm.application_id

Line 10653: FROM ZX_EVNT_TYP_MAPPINGS zxevntmap,

10649: SELECT zxevnttyp.tax_event_type_code,
10650: zxevnttyp.status_code
10651: INTO l_event_class_rec.tax_event_type_code,
10652: l_event_class_rec.doc_status_code
10653: FROM ZX_EVNT_TYP_MAPPINGS zxevntmap,
10654: ZX_EVNT_CLS_TYPS zxevnttyp
10655: WHERE zxevntmap.event_class_code = p_hdr_det_factors_rec.event_class_code
10656: AND zxevntmap.application_id = p_hdr_det_factors_rec.application_id
10657: AND zxevntmap.entity_code = p_hdr_det_factors_rec.entity_code