APPS.AP_ETAX_SERVICES_PKG dependencies on ZX_REC_NREC_DIST

Line 9972: zx_rec_nrec_dist zx_dist

9968: 'N' rcv_charge_addition_flag,
9969: tax_dist.prepay_tax_diff_amount -- BUG 7338249
9970: from ap_invoice_distributions_all tax_dist,
9971: ap_invoice_distributions_all item_dist,
9972: zx_rec_nrec_dist zx_dist
9973: where tax_dist.invoice_id = p_invoice_id
9974: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')
9975: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id
9976: and item_dist.invoice_distribution_id(+) = zx_dist.trx_line_dist_id --bug7394712

Line 10178: zx_rec_nrec_dist zx_dist

10174: 'N' rcv_charge_addition_flag,
10175: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10176: from ap_invoice_distributions_all tax_dist,
10177: ap_invoice_distributions_all item_dist,
10178: zx_rec_nrec_dist zx_dist
10179: where tax_dist.invoice_id = p_invoice_id
10180: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')
10181: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id
10182: and item_dist.invoice_distribution_id(+) = zx_dist.trx_line_dist_id --bug7394712

Line 10388: zx_rec_nrec_dist zx_dist

10384: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
10385: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10386: from ap_self_assessed_tax_dist_all tax_dist,
10387: ap_invoice_distributions_all item_dist,
10388: zx_rec_nrec_dist zx_dist
10389: where tax_dist.invoice_id = p_invoice_id
10390: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')
10391: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id
10392: and item_dist.invoice_distribution_id(+) = zx_dist.trx_line_dist_id --bug7394712

Line 10605: zx_rec_nrec_dist zx_dist

10601: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
10602: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10603: from ap_self_assessed_tax_dist_all tax_dist,
10604: ap_invoice_distributions_all item_dist,
10605: zx_rec_nrec_dist zx_dist
10606: where tax_dist.invoice_id = p_invoice_id
10607: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')
10608: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id
10609: and item_dist.invoice_distribution_id(+) = zx_dist.trx_line_dist_id --bug7394712

Line 10706: zx_rec_nrec_dist zx_dist

10702: zx_dist.tax_line_id reversed_tax_line_id
10703: from ap_invoice_distributions_all item_dist,
10704: ap_invoice_distributions_all tax_dist,
10705: ap_invoice_distributions_all reverse_dist,
10706: zx_rec_nrec_dist zx_dist
10707: where tax_dist.invoice_id = p_invoice_id
10708: and tax_dist.invoice_id = item_dist.invoice_id
10709: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id
10710: and item_dist.invoice_distribution_id = reverse_dist.parent_reversal_id

Line 10780: zx_rec_nrec_dist zx_dist

10776: zx_dist.tax_line_id reversed_tax_line_id
10777: from ap_invoice_distributions_all item_dist,
10778: ap_self_assessed_tax_dist_all tax_dist,
10779: ap_invoice_distributions_all reverse_dist,
10780: zx_rec_nrec_dist zx_dist
10781: where tax_dist.invoice_id = p_invoice_id
10782: and tax_dist.invoice_id = item_dist.invoice_id
10783: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id
10784: and item_dist.invoice_distribution_id = reverse_dist.parent_reversal_id

Line 12223: from zx_rec_nrec_dist zx

12219: END IF;
12220:
12221: UPDATE ap_invoice_distributions_all aid
12222: SET reversal_flag = (select reverse_flag
12223: from zx_rec_nrec_dist zx
12224: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
12225: WHERE aid.invoice_id = p_invoice_id
12226: AND aid.detail_tax_dist_id IS NOT NULL;
12227:

Line 12269: from zx_rec_nrec_dist zx

12265: END IF;
12266:
12267: UPDATE ap_self_assessed_tax_dist_all aid
12268: SET reversal_flag = (select reverse_flag
12269: from zx_rec_nrec_dist zx
12270: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
12271: WHERE aid.invoice_id = p_invoice_id
12272: AND aid.detail_tax_dist_id IS NOT NULL;
12273:

Line 12833: -- associated with an invoice. Join with zx_rec_nrec_dist is required becase

12829: RETURN FALSE;
12830: END TAX_ONLY_LINE_EXIST;
12831:
12832: /* Bug 6694536. Added function to verify whether there are self assessed tax lines
12833: -- associated with an invoice. Join with zx_rec_nrec_dist is required becase
12834: -- self_assessed_flag of zx_rec_nrec_dist actually indicates whether the lines
12835: -- are self assessed or not.
12836: */
12837:

Line 12834: -- self_assessed_flag of zx_rec_nrec_dist actually indicates whether the lines

12830: END TAX_ONLY_LINE_EXIST;
12831:
12832: /* Bug 6694536. Added function to verify whether there are self assessed tax lines
12833: -- associated with an invoice. Join with zx_rec_nrec_dist is required becase
12834: -- self_assessed_flag of zx_rec_nrec_dist actually indicates whether the lines
12835: -- are self assessed or not.
12836: */
12837:
12838: FUNCTION SELF_ASSESS_TAX_DIST_EXIST

Line 12847: zx_rec_nrec_dist zx_dist

12843: BEGIN
12844: SELECT 'Tax Distributions Exist'
12845: INTO l_dummy
12846: FROM ap_self_assessed_tax_dist_all asat,
12847: zx_rec_nrec_dist zx_dist
12848: WHERE invoice_id = p_invoice_id
12849: AND asat.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
12850: AND zx_dist.self_assessed_flag = 'Y'
12851: AND nvl(zx_dist.reverse_flag, 'N') <> 'Y'

Line 13731: zx_rec_nrec_dist zx

13727: aid_parent.invoice_distribution_id parent_reversal_id,
13728: aid_parent.dist_code_combination_id parent_ccid
13729: FROM ap_invoice_distributions_all aid_reverse,
13730: ap_invoice_distributions_all aid_parent,
13731: zx_rec_nrec_dist zx
13732: WHERE aid_reverse.invoice_id = c_invoice_id
13733: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id
13734: AND aid_parent.detail_tax_dist_id = zx.reversed_tax_dist_id
13735: AND aid_parent.line_type_lookup_code = aid_reverse.line_type_lookup_code;

Line 13838: FROM zx_rec_nrec_dist zd

13834:
13835: UPDATE ap_invoice_distributions_all aid
13836: SET rounding_amt =
13837: (SELECT zd.func_curr_rounding_adjustment
13838: FROM zx_rec_nrec_dist zd
13839: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
13840: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
13841: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
13842: AND (aid.related_id IS NULL

Line 13856: FROM zx_rec_nrec_dist zd

13852:
13853: UPDATE ap_self_assessed_tax_dist_all aid
13854: SET rounding_amt =
13855: (SELECT zd.func_curr_rounding_adjustment
13856: FROM zx_rec_nrec_dist zd
13857: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
13858: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
13859: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
13860: AND (aid.related_id IS NULL

Line 13888: FROM zx_rec_nrec_dist zd

13884: 0)),
13885: SUM(DECODE(NVL(zd.recoverable_flag, 'N'),
13886: 'N', NVL(zd.rec_nrec_tax_amt_funcl_curr, 0),
13887: 0))
13888: FROM zx_rec_nrec_dist zd
13889: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
13890: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
13891: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
13892: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 13920: zx_rec_nrec_dist zd

13916: AND NVL(aid.tax_already_distributed_flag, 'N') = 'N'
13917: AND aid.invoice_distribution_id IN
13918: ( SELECT aid1.charge_applicable_to_dist_id
13919: FROM ap_invoice_distributions_all aid1,
13920: zx_rec_nrec_dist zd
13921: WHERE zd.REC_NREC_TAX_DIST_ID = aid1.DETAIL_TAX_DIST_ID
13922: AND aid1.invoice_id = p_invoice_header_rec.invoice_id );
13923:
13924: -----------------------------------------------------------------

Line 14086: from zx_rec_nrec_dist zx

14082: END IF;
14083:
14084: UPDATE ap_invoice_distributions_all aid
14085: SET reversal_flag = (select reverse_flag
14086: from zx_rec_nrec_dist zx
14087: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
14088: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id
14089: AND aid.detail_tax_dist_id IS NOT NULL;
14090: