eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_ETDS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 357: FROM ap_invoice_distributions_all a, ap_invoice_distributions_all b

353: /*added by csahoo for bug # 6158875, END*/
354:
355: CURSOR c_prepay_invoice_id(p_tds_invoice_id IN NUMBER) IS
356: SELECT b.invoice_id prepay_invoice_id
357: FROM ap_invoice_distributions_all a, ap_invoice_distributions_all b
358: WHERE a.invoice_id = p_tds_invoice_id
359: AND a.prepay_distribution_id IS NOT NULL
360: AND (a.reversal_flag IS NULL OR a.reversal_flag = 'N') --rchandan for bug#4428980
361: AND b.invoice_distribution_id = a.prepay_distribution_id;

Line 697: from ap_invoice_distributions_all

693:
694: IF dtl.inv_type = 'PREPAYMENT' THEN
695: v_statement_id := '3g';
696: select sum(amount) - sum( nvl(prepay_amount_remaining, amount)) INTO v_prepayment_amount_applied
697: from ap_invoice_distributions_all
698: where invoice_id = dtl.base_invoice_id
699: and attribute1 = dtl.tds_tax_id;
700: END IF;
701:

Line 3255: CURSOR c_base_inv_gl_date(p_invoice_id IN NUMBER, p_tax_id IN NUMBER,p_line_type ap_invoice_distributions_all.line_type_lookup_code%type) IS

3251: NVL(challan_num,'No Challan Number'), NVL(challan_date,lv_dummy_date),
3252: check_number,tds_tax_rate;
3253: dd c_deductee_records%ROWTYPE ;
3254:
3255: CURSOR c_base_inv_gl_date(p_invoice_id IN NUMBER, p_tax_id IN NUMBER,p_line_type ap_invoice_distributions_all.line_type_lookup_code%type) IS
3256: SELECT accounting_date
3257: FROM ap_invoice_distributions_all
3258: WHERE invoice_id = p_invoice_id
3259: AND line_type_lookup_code = p_line_type

Line 3257: FROM ap_invoice_distributions_all

3253: dd c_deductee_records%ROWTYPE ;
3254:
3255: CURSOR c_base_inv_gl_date(p_invoice_id IN NUMBER, p_tax_id IN NUMBER,p_line_type ap_invoice_distributions_all.line_type_lookup_code%type) IS
3256: SELECT accounting_date
3257: FROM ap_invoice_distributions_all
3258: WHERE invoice_id = p_invoice_id
3259: AND line_type_lookup_code = p_line_type
3260: AND global_attribute1 = to_char(p_tax_id);--rchandan for bug#4333488
3261:

Line 3749: be populated in the attribute columns of ap_invoice_distributions_all table

3745:
3746: 7. 8/05/2005 rchandan for bug#4333488. Version 116.1
3747: The Invoice Distribution DFF is eliminated and a new global DFF is used to
3748: maintain the functionality. From now the TDS tax, WCT tax and ESSI will not
3749: be populated in the attribute columns of ap_invoice_distributions_all table
3750: instead these will be populated in the global attribute columns. So the code changes are
3751: made accordingly.Both Payment and India distributions DFF elimintion is taken care of in
3752: the same version.
3753: