APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_PREPAYMENTS

Line 509: FROM jai_ap_tds_prepayments jatp

505: \*Bug 11896260 - Start*\
506: CURSOR c_get_pp_apply_amt (p_invoice_id IN NUMBER)
507: IS
508: SELECT SUM(application_amount)
509: FROM jai_ap_tds_prepayments jatp
510: WHERE invoice_id = p_invoice_id
511: AND (SELECT accounting_date
512: FROM ap_invoice_distributions_all
513: WHERE invoice_distribution_id = jatp.invoice_distribution_id)

Line 525: FROM jai_ap_tds_prepayments jatp

521: );
522: CURSOR c_get_applied_amt (p_invoice_id IN NUMBER)
523: IS
524: SELECT SUM(application_amount)
525: FROM jai_ap_tds_prepayments jatp
526: WHERE invoice_id IN (SELECT invoice_id
527: FROM ap_invoice_distributions_all
528: WHERE prepay_distribution_id IN (SELECT invoice_distribution_id
529: FROM ap_invoice_distributions_all

Line 1191: FROM jai_ap_tds_prepayments

1187: AND jatit.threshold_grp_id IS NOT NULL
1188: AND jatit.threshold_grp_id = c_get_threshold_grp.threshold_grp_id
1189: AND aia.cancelled_date IS NULL
1190: AND NOT EXISTS (SELECT 1
1191: FROM jai_ap_tds_prepayments
1192: WHERE invoice_id = jatit.invoice_id)
1193: AND nvl(jatit.actual_tax_id, jatit.default_tax_id) = jitc.tax_id
1194: AND aia.vendor_id = jte.vendor_id
1195: AND aia.vendor_site_id = jte.vendor_site_id

Line 1291: FROM jai_ap_tds_prepayments

1287: AND jatit.threshold_grp_id IS NOT NULL
1288: AND jatit.threshold_grp_id = c_get_threshold_grp.threshold_grp_id
1289: AND aia.cancelled_date IS NULL
1290: AND (EXISTS (SELECT 1
1291: FROM jai_ap_tds_prepayments
1292: WHERE invoice_id = jatit.invoice_id)
1293: OR aida.prepay_amount_remaining IS NOT NULL)
1294: AND nvl(jatit.actual_tax_id, jatit.default_tax_id) = jitc.tax_id
1295: AND aia.vendor_id = jte.vendor_id

Line 1760: FROM jai_ap_tds_prepayments jatp

1756: /*Bug 11896260 - Start*/
1757: CURSOR c_get_pp_apply_amt (p_invoice_id IN NUMBER)
1758: IS
1759: SELECT SUM(application_amount)
1760: FROM jai_ap_tds_prepayments jatp
1761: WHERE invoice_id = p_invoice_id
1762: AND (SELECT accounting_date
1763: FROM ap_invoice_distributions_all
1764: WHERE invoice_distribution_id = jatp.invoice_distribution_id)

Line 1776: FROM jai_ap_tds_prepayments jatp

1772: );
1773: CURSOR c_get_applied_amt (p_invoice_id IN NUMBER)
1774: IS
1775: SELECT SUM(application_amount)
1776: FROM jai_ap_tds_prepayments jatp
1777: WHERE invoice_id IN (SELECT invoice_id
1778: FROM ap_invoice_distributions_all
1779: WHERE prepay_distribution_id IN (SELECT invoice_distribution_id
1780: FROM ap_invoice_distributions_all