APPS.JAI_AP_TDS_PREPAYMENTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 202: FROM ap_invoice_distributions_all

198: BEGIN
199: BEGIN
200: SELECT invoice_id
201: INTO p_prepay_inv_id
202: FROM ap_invoice_distributions_all
203: WHERE invoice_distribution_id = p_prepay_inv_dist_id;
204: EXCEPTION
205: WHEN NO_DATA_FOUND THEN
206: p_prepay_inv_id := null;

Line 216: FROM ap_invoice_distributions_all

212: IS
213: PRAGMA AUTONOMOUS_TRANSACTION;
214: CURSOR c_get_reversal_flag(p_inv_dist_id NUMBER) is
215: SELECT reversal_flag
216: FROM ap_invoice_distributions_all
217: WHERE invoice_distribution_id = p_inv_dist_id;
218: v_reversal_flag VARCHAR2(1);
219: BEGIN
220: OPEN c_get_reversal_flag(pn_invoice_dist_id);

Line 572: ln_inv_dist_id_apply ap_invoice_distributions_all.invoice_distribution_id%TYPE ;

568: lv_ppu_tds_inv_num ap_invoices_all.invoice_num%type;
569: lv_ppu_tds_cm_num ap_invoices_all.invoice_num%type;
570: /*Bug 5751783 - End*/
571: -- Bug 6031679. Added by Lakshmi Gopalsami
572: ln_inv_dist_id_apply ap_invoice_distributions_all.invoice_distribution_id%TYPE ;
573:
574:
575: begin
576: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */

Line 1211: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483

1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;
1209: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;
1210:
1211: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1212:
1213:
1214: begin
1215:

Line 1615: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483

1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1613: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1614: /*Bug 6363056 - End*/
1615: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1616: /*START, Bgowrava for Bug#7626202*/
1617: ln_tot_tds_amt number := 0;
1618: ln_tot_appln_amt number := 0;
1619: /*END, Bgowrava for Bug#7626202*/