APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_REC_NREC_DIST

Line 3041: -- Insert data into zx_lines and zx_rec_nrec_dist

3037: 'INTEREST INVOICE', 'INTEREST INVOICES','NA')
3038: AND zxdet.TRX_ID = inv.invoice_id);
3039:
3040:
3041: -- Insert data into zx_lines and zx_rec_nrec_dist
3042: --
3043: INSERT ALL
3044: INTO ZX_REC_NREC_DIST(
3045: TAX_LINE_ID

Line 3044: INTO ZX_REC_NREC_DIST(

3040:
3041: -- Insert data into zx_lines and zx_rec_nrec_dist
3042: --
3043: INSERT ALL
3044: INTO ZX_REC_NREC_DIST(
3045: TAX_LINE_ID
3046: ,REC_NREC_TAX_DIST_ID
3047: ,REC_NREC_TAX_DIST_NUMBER
3048: ,APPLICATION_ID

Line 5840: INSERT INTO ZX_REC_NREC_DIST

5836: AND zxl.ENTITY_CODE = NVL2(poll.po_release_id, 'RELEASE','PURCHASE_ORDER'));
5837:
5838: -- COMMIT;
5839:
5840: INSERT INTO ZX_REC_NREC_DIST
5841: (TAX_LINE_ID
5842: ,REC_NREC_TAX_DIST_ID
5843: ,REC_NREC_TAX_DIST_NUMBER
5844: ,APPLICATION_ID

Line 5981: zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID,

5977: ,OBJECT_VERSION_NUMBER
5978: )
5979: SELECT /*+ NO_EXPAND leading(pohzd) use_nl(fc, rates)*/
5980: pohzd.tax_line_id TAX_LINE_ID,
5981: zx_rec_nrec_dist_s.nextval REC_NREC_TAX_DIST_ID,
5982: RANK() OVER
5983: (PARTITION BY pohzd.trx_id,
5984: pohzd.p_po_distribution_id
5985: ORDER BY pohzd.tax_rate_id,

Line 6319: (SELECT 1 FROM zx_rec_nrec_dist zxdist

6315: AND rates.record_type_code(+) = 'MIGRATED'
6316: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)
6317: AND rates.tax_rate_code(+) NOT LIKE 'AD_HOC_RECOVERY%'
6318: AND NOT EXISTS
6319: (SELECT 1 FROM zx_rec_nrec_dist zxdist
6320: WHERE zxdist.APPLICATION_ID = 201
6321: AND zxdist.ENTITY_CODE = pohzd.ENTITY_CODE
6322: AND zxdist.EVENT_CLASS_CODE = pohzd.EVENT_CLASS_CODE
6323: AND zxdist.TRX_ID = pohzd.trx_id );