APPS.AP_INVOICE_LINES_PKG dependencies on ZX_REC_NREC_DIST

Line 2246: zx_rec_nrec_dist zx_dist

2242: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount,
2243: tax_dist.pay_awt_group_id pay_awt_group_id
2244: from ap_invoice_distributions_all tax_dist,
2245: ap_invoice_distributions_all item_dist,
2246: zx_rec_nrec_dist zx_dist
2247: where tax_dist.invoice_id = c_invoice_id
2248: and tax_dist.invoice_id = zx_dist.trx_id
2249: and zx_dist.application_id = 200
2250: and zx_dist.entity_code = 'AP_INVOICES'

Line 2454: zx_rec_nrec_dist zx_dist

2450: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
2451: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount
2452: from ap_self_assessed_tax_dist_all tax_dist,
2453: ap_invoice_distributions_all item_dist,
2454: zx_rec_nrec_dist zx_dist
2455: where tax_dist.invoice_id = c_invoice_id
2456: and tax_dist.invoice_id = zx_dist.trx_id
2457: and zx_dist.application_id = 200
2458: and zx_dist.entity_code = 'AP_INVOICES'

Line 3627: from zx_rec_nrec_dist zx

3623: -----------------------------------------------------------------
3624:
3625: UPDATE ap_invoice_distributions_all aid
3626: SET reversal_flag = (select reverse_flag
3627: from zx_rec_nrec_dist zx
3628: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
3629: WHERE aid.invoice_id = p_line_rec.invoice_id
3630: AND aid.detail_tax_dist_id IS NOT NULL;
3631:

Line 3667: from zx_rec_nrec_dist zx

3663: -----------------------------------------------------------------
3664:
3665: UPDATE ap_self_assessed_tax_dist_all aid
3666: SET reversal_flag = (select reverse_flag
3667: from zx_rec_nrec_dist zx
3668: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
3669: WHERE aid.invoice_id = p_line_rec.invoice_id
3670: AND aid.detail_tax_dist_id IS NOT NULL;
3671:

Line 5519: zx_rec_nrec_dist zx_dist

5515: zx_dist.tax_line_id reversed_tax_line_id
5516: from ap_invoice_distributions_all item_dist,
5517: ap_invoice_distributions_all tax_dist,
5518: ap_invoice_distributions_all reverse_dist,
5519: zx_rec_nrec_dist zx_dist
5520: where tax_dist.invoice_id = p_inv_line_rec.invoice_id
5521: and tax_dist.invoice_id = item_dist.invoice_id
5522: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id
5523: and item_dist.invoice_distribution_id = reverse_dist.parent_reversal_id

Line 5582: zx_rec_nrec_dist zx_dist

5578: zx_dist.tax_line_id reversed_tax_line_id
5579: from ap_invoice_distributions_all item_dist,
5580: ap_self_assessed_tax_dist_all tax_dist,
5581: ap_invoice_distributions_all reverse_dist,
5582: zx_rec_nrec_dist zx_dist
5583: where tax_dist.invoice_id = p_inv_line_rec.invoice_id
5584: and tax_dist.invoice_id = item_dist.invoice_id
5585: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id
5586: and item_dist.invoice_distribution_id = reverse_dist.parent_reversal_id

Line 5679: zx_rec_nrec_dist zx_dist

5675:
5676: SELECT ' self assess Tax Distributions Exist'
5677: INTO l_dummy
5678: FROM ap_self_assessed_tax_dist_all asat,
5679: zx_rec_nrec_dist zx_dist
5680: WHERE asat.invoice_id = p_invoice_id
5681: AND asat.invoice_line_number = p_line_number
5682: AND asat.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
5683: AND zx_dist.self_assessed_flag = 'Y'