APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_PREPAYMENTS

Line 551: from jai_ap_tds_prepayments a,

547: is
548: PRAGMA AUTONOMOUS_TRANSACTION;
549: cursor c_jai_apply_amount(cp_invoice_id number) is
550: select sum(a.application_amount) application_amount, d.threshold_grp_id, d.invoice_id
551: from jai_ap_tds_prepayments a,
552: ap_invoice_distributions_all b,
553: ap_invoice_distributions_all c,
554: jai_ap_tds_inv_taxes d
555: where a.invoice_distribution_id_prepay = b.invoice_distribution_id

Line 569: from jai_ap_tds_prepayments a,

565: incorrect TDS deducted during Threshold Transition. Derive the Prepayments(which suffered TDS)
566: applied and subtract the same before calculating Effective amount for Threshold Transition*/
567: cursor c_pp_single_apply_amount(cp_invoice_id number) is
568: select sum(application_amount) amount
569: from jai_ap_tds_prepayments a,
570: ap_invoice_distributions_all b
571: where a.invoice_id = cp_invoice_id
572: and a.invoice_id = b.invoice_id
573: and a.invoice_distribution_id_prepay = b.invoice_distribution_id

Line 1082: from jai_ap_tds_prepayments

1078: -------------------------------------------------------------------------------
1079: /*Added parameter section_type fro bug 11070443*/
1080: cursor c_get_amount_already_applied(p_invoice_distribution_id number, p_section_type varchar2) is
1081: select sum(application_amount)
1082: from jai_ap_tds_prepayments
1083: where invoice_distribution_id = p_invoice_distribution_id
1084: and (
1085: (p_section_type = 'TDS_SECTION' and nvl(tds_applicable_flag, '*') = 'Y') or
1086: (p_section_type = 'WCT_SECTION' and nvl(wct_applicable_flag, '*') = 'Y') or

Line 2904: FROM jai_ap_tds_prepayments jatp

2900: /* Get the prepayment amount which is applied and RTN invoice is not yet generated. */
2901: CURSOR get_ppau_tds_not_deducted (cp_threshold_grp_id IN NUMBER )
2902: IS
2903: SELECT SUM (NVL (jatp.application_amount, 0 ))
2904: FROM jai_ap_tds_prepayments jatp
2905: WHERE jatp.tds_threshold_grp_id = cp_threshold_grp_id
2906: AND jatp.tds_applicable_flag = 'Y'
2907: AND jatp.tds_threshold_trx_id_apply IS NULL
2908: AND (jatp.unapply_flag IS NULL OR jatp.unapply_flag = 'N') ;

Line 4299: FROM jai_ap_tds_prepayments

4295:
4296: CURSOR c_check_prepayment_apply(p_invoice_distribution_id NUMBER)
4297: IS
4298: SELECT '1'
4299: FROM jai_ap_tds_prepayments
4300: WHERE invoice_distribution_id_prepay = p_invoice_distribution_id;
4301:
4302: CURSOR c_check_prepayment_unapply(p_invoice_distribution_id_pp NUMBER)
4303: IS

Line 4305: FROM jai_ap_tds_prepayments

4301:
4302: CURSOR c_check_prepayment_unapply(p_invoice_distribution_id_pp NUMBER)
4303: IS
4304: SELECT '1'
4305: FROM jai_ap_tds_prepayments
4306: WHERE invoice_distribution_id_prepay = p_invoice_distribution_id_pp
4307: AND unapply_flag = 'Y';
4308: --End addition by sanjikum for Bug#5131075(4722011)
4309:

Line 4481: jai_ap_tds_prepayments_pkg.process_prepayment

4477: if lv_new_transaction_si = 'Y' and lv_new_transaction_pp = 'Y' then
4478:
4479: lv_codepath := null;
4480:
4481: jai_ap_tds_prepayments_pkg.process_prepayment
4482: (
4483: p_event => 'INSERT', --Added for Bug 8431516
4484: p_invoice_id => i.invoice_id,
4485: p_invoice_distribution_id => i.invoice_distribution_id,

Line 4509: jai_ap_tds_prepayments_pkg.process_old_transaction

4505: end if;
4506:
4507: else
4508: --Invoke the old regime functionality
4509: jai_ap_tds_prepayments_pkg.process_old_transaction
4510: (
4511: p_invoice_id => i.invoice_id,
4512: p_invoice_distribution_id => i.invoice_distribution_id,
4513: p_prepay_distribution_id => i.prepay_distribution_id,

Line 4720: FROM jai_ap_tds_prepayments

4716:
4717: CURSOR c_prepayments(c_threshold_grp_id NUMBER)
4718: IS
4719: SELECT *
4720: FROM jai_ap_tds_prepayments
4721: WHERE tds_threshold_grp_id = c_threshold_grp_id
4722: AND NVL(unapply_flag,'N') <> 'Y';
4723:
4724: CURSOR c_thhold_trxs(p_invoice_distribution_id NUMBER,

Line 4782: FROM jai_ap_tds_prepayments jatp

4778: */
4779: CURSOR get_ppau_tds_not_deducted (cp_threshold_grp_id IN NUMBER )
4780: IS
4781: SELECT SUM (NVL (jatp.application_amount, 0 ))
4782: FROM jai_ap_tds_prepayments jatp
4783: WHERE jatp.tds_threshold_grp_id = cp_threshold_grp_id
4784: AND jatp.tds_applicable_flag = 'Y'
4785: AND jatp.tds_threshold_trx_id_apply IS NULL
4786: AND jatp.unapply_flag IS NULL OR jatp.unapply_flag = 'N' ;