APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REC_NREC_DIST

Line 506: FROM ZX_REC_NREC_DIST

502: AND ROWNUM=1
503: )
504: AND EXISTS
505: (SELECT 1
506: FROM ZX_REC_NREC_DIST
507: WHERE REC_NREC_TAX_DIST_ID = DTL.ACTG_SOURCE_ID
508: );
509:
510: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 708: FROM zx_rec_nrec_dist ZX_DIST

704: -- similar to 11i, to stamp the recovery rate
705:
706: UPDATE ZX_REP_TRX_DETAIL_T DTL
707: SET DTL.TAX_RECOVERY_RATE = (SELECT (ZX_DIST.rec_nrec_tax_amt/ZX_DIST.trx_line_dist_tax_amt)*100
708: FROM zx_rec_nrec_dist ZX_DIST
709: WHERE DTL.EXTRACT_SOURCE_LEDGER = 'AP'
710: AND ZX_DIST.rec_nrec_tax_dist_id = DTL.actg_source_id
711: AND abs(ZX_DIST.trx_line_dist_tax_amt) > abs(ZX_DIST.rec_nrec_tax_amt)
712: AND ZX_DIST.rec_nrec_tax_amt <> 0

Line 716: AND EXISTS(SELECT 1 FROM zx_rec_nrec_dist ZX_DIST1

712: AND ZX_DIST.rec_nrec_tax_amt <> 0
713: )
714: WHERE DTL.REQUEST_ID = P_REQUEST_ID
715: AND DTL.HISTORICAL_FLAG = 'Y'
716: AND EXISTS(SELECT 1 FROM zx_rec_nrec_dist ZX_DIST1
717: WHERE ZX_DIST1.rec_nrec_tax_dist_id = DTL.actg_source_id
718: AND abs(ZX_DIST1.trx_line_dist_tax_amt) > abs(ZX_DIST1.rec_nrec_tax_amt)
719: AND ZX_DIST1.rec_nrec_tax_amt <> 0
720: );