APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_REC_NREC_DIST

Line 2980: -- Insert data into zx_lines and zx_rec_nrec_dist

2976: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
2977: AND zxdet.TRX_ID = inv.invoice_id);
2978:
2979:
2980: -- Insert data into zx_lines and zx_rec_nrec_dist
2981: --
2982: INSERT ALL
2983: INTO ZX_REC_NREC_DIST(
2984: TAX_LINE_ID

Line 2983: INTO ZX_REC_NREC_DIST(

2979:
2980: -- Insert data into zx_lines and zx_rec_nrec_dist
2981: --
2982: INSERT ALL
2983: INTO ZX_REC_NREC_DIST(
2984: TAX_LINE_ID
2985: ,REC_NREC_TAX_DIST_ID
2986: ,REC_NREC_TAX_DIST_NUMBER
2987: ,APPLICATION_ID

Line 5049: INSERT INTO ZX_REC_NREC_DIST

5045: AND zxl.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE','PURCHASE_ORDER'));
5046:
5047: -- COMMIT;
5048:
5049: INSERT INTO ZX_REC_NREC_DIST
5050: (TAX_LINE_ID
5051: ,REC_NREC_TAX_DIST_ID
5052: ,REC_NREC_TAX_DIST_NUMBER
5053: ,APPLICATION_ID

Line 5190: zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID,

5186: ,OBJECT_VERSION_NUMBER
5187: )
5188: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
5189: pohzd.tax_line_id TAX_LINE_ID,
5190: zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID,
5191: RANK() OVER
5192: (PARTITION BY pohzd.trx_id,
5193: pohzd.p_po_distribution_id
5194: ORDER BY pohzd.tax_rate_id,

Line 5457: (SELECT 1 FROM zx_rec_nrec_dist zxdist

5453: AND rates.record_type_code(+) = 'MIGRATED'
5454: AND rates.percentage_rate(+) = NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate)
5455: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
5456: AND NOT EXISTS
5457: (SELECT 1 FROM zx_rec_nrec_dist zxdist
5458: WHERE zxdist.APPLICATION_ID = 201
5459: AND zxdist.ENTITY_CODE = pohzd.ENTITY_CODE
5460: AND zxdist.EVENT_CLASS_CODE = pohzd.EVENT_CLASS_CODE
5461: AND zxdist.TRX_ID = pohzd.trx_id );