APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_PREPAYMENTS

Line 3075: FROM jai_ap_tds_prepayments

3071:
3072: CURSOR c_check_prepayment_apply(p_invoice_distribution_id NUMBER)
3073: IS
3074: SELECT '1'
3075: FROM jai_ap_tds_prepayments
3076: WHERE invoice_distribution_id_prepay = p_invoice_distribution_id;
3077:
3078: CURSOR c_check_prepayment_unapply(p_invoice_distribution_id_pp NUMBER)
3079: IS

Line 3081: FROM jai_ap_tds_prepayments

3077:
3078: CURSOR c_check_prepayment_unapply(p_invoice_distribution_id_pp NUMBER)
3079: IS
3080: SELECT '1'
3081: FROM jai_ap_tds_prepayments
3082: WHERE invoice_distribution_id_prepay = p_invoice_distribution_id_pp
3083: AND unapply_flag = 'Y';
3084: --End addition by sanjikum for Bug#5131075(4722011)
3085:

Line 3237: jai_ap_tds_prepayments_pkg.process_prepayment

3233: if lv_new_transaction_si = 'Y' and lv_new_transaction_pp = 'Y' then
3234:
3235: lv_codepath := null;
3236:
3237: jai_ap_tds_prepayments_pkg.process_prepayment
3238: (
3239: p_invoice_id => i.invoice_id,
3240: p_invoice_distribution_id => i.invoice_distribution_id,
3241: p_prepay_distribution_id => i.prepay_distribution_id,

Line 3264: jai_ap_tds_prepayments_pkg.process_old_transaction

3260: end if;
3261:
3262: else
3263: --Invoke the old regime functionality
3264: jai_ap_tds_prepayments_pkg.process_old_transaction
3265: (
3266: p_invoice_id => i.invoice_id,
3267: p_invoice_distribution_id => i.invoice_distribution_id,
3268: p_prepay_distribution_id => i.prepay_distribution_id,

Line 3475: FROM jai_ap_tds_prepayments

3471:
3472: CURSOR c_prepayments(c_threshold_grp_id NUMBER)
3473: IS
3474: SELECT *
3475: FROM jai_ap_tds_prepayments
3476: WHERE tds_threshold_grp_id = c_threshold_grp_id
3477: AND NVL(unapply_flag,'N') <> 'Y';
3478:
3479: CURSOR c_thhold_trxs(p_invoice_distribution_id NUMBER,