APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_AP_TDS_PREPAYMENTS

Line 252: FROM jai_ap_tds_prepayments jatp

248: ,jatp.invoice_id
249: ,jatp.invoice_distribution_id_prepay
250: ,jatp.invoice_distribution_id
251: ,application_amount
252: FROM jai_ap_tds_prepayments jatp
253: WHERE NVL(NVL(jatp.tds_threshold_trx_id_apply, jatp.wct_threshold_trx_id_apply)
254: ,jatp.essi_threshold_trx_id_apply) = pn_threshold_trx_id
255: ;
256:

Line 264: FROM jai_ap_tds_prepayments jatp

260: ,jatp.invoice_id
261: ,jatp.invoice_distribution_id_prepay
262: ,jatp.invoice_distribution_id
263: ,application_amount
264: FROM jai_ap_tds_prepayments jatp
265: WHERE NVL(NVL(jatp.tds_threshold_trx_id_unapply, jatp.wct_threshold_trx_id_unapply)
266: ,jatp.essi_threshold_trx_id_unapply) = pn_threshold_trx_id
267: ;
268:

Line 440: --Need derive apply from/to info from jai_ap_tds_prepayments table.

436: --IF pn_invoice_id IS NOT NULL AND pn_invoice_id NOT IN (-9999, -9997) THEN
437: IF r_c_get_trx_tds_info.threshold_trx_id IS NOT NULL THEN
438: --RTN TDS invoice created.
439: --As in this situation code is invoked while populdate TDS invoice, prepay_distribtuion and inv distribtuion not populdated.
440: --Need derive apply from/to info from jai_ap_tds_prepayments table.
441: IF pv_event = G_PREPAYMENT_APPLICATION THEN
442: --Application prepayment
443: OPEN c_get_apply_prepayments_info(r_c_get_trx_tds_info.threshold_trx_id);
444: FETCH c_get_apply_prepayments_info INTO r_get_apply_prepayments_info;

Line 1088: FROM jai_ap_tds_prepayments jatp

1084: ,jatp.WCT_THRESHOLD_TRX_ID_APPLY
1085: ,jatp.WCT_THRESHOLD_TRX_ID_UNAPPLY
1086: ,jatp.ESSI_THRESHOLD_TRX_ID_APPLY
1087: ,jatp.ESSI_THRESHOLD_TRX_ID_UNAPPLY
1088: FROM jai_ap_tds_prepayments jatp
1089: WHERE jatp.tds_threshold_grp_id = r_thhold_grp_rec.threshold_grp_id
1090: )
1091: LOOP
1092: --process TDS application

Line 1447: FROM jai_ap_tds_prepayments

1443: AND jatit.threshold_grp_id IS NOT NULL
1444: AND jatit.threshold_grp_id = r_thhold_grp_rec.threshold_grp_id
1445: AND aia.cancelled_date IS NULL
1446: AND NOT EXISTS (SELECT 1
1447: FROM jai_ap_tds_prepayments
1448: WHERE invoice_id = jatit.invoice_id)
1449: AND nvl(jatit.actual_tax_id, jatit.default_tax_id) = jitc.tax_id
1450: AND aia.vendor_id = jte.vendor_id
1451: AND aia.vendor_site_id = jte.vendor_site_id

Line 1579: FROM jai_ap_tds_prepayments

1575: AND jatit.threshold_grp_id IS NOT NULL
1576: AND jatit.threshold_grp_id = r_thhold_grp_rec.threshold_grp_id
1577: AND aia.cancelled_date IS NULL
1578: AND (EXISTS (SELECT 1
1579: FROM jai_ap_tds_prepayments
1580: WHERE invoice_id = jatit.invoice_id)
1581: OR aida.prepay_amount_remaining IS NOT NULL)
1582: AND nvl(jatit.actual_tax_id, jatit.default_tax_id) = jitc.tax_id
1583: AND aia.vendor_id = jte.vendor_id