APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_CMN_TAXES_ALL

Line 16: ln_final_tds_tax_id JAI_CMN_TAXES_ALL.tax_id%type;

12: */
13: PROCEDURE BRIUD_DTC_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
14: lv_process_flag varchar2(20);
15: lv_process_message varchar2(200);
16: ln_final_tds_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
17:
18: cursor c_ap_invoices_all is
19: select ai.vendor_id,
20: ai.vendor_site_id,

Line 87: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

83: AND trunc (p_inv_date) between start_date and end_date ; -- Modified by Jia for FP Bug#8656402, change sysdate to p_inv_date
84: /*START, by amandali for Bug#10430662*/
85: cursor c_receipt_wct_tax(p_shipment_line_id number) is
86: select a.tax_id
87: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
88: where a.tax_id = b.tax_id
89: and a.shipment_line_id = p_shipment_line_id
90: and a.tax_type = 'TDS'
91: and b.section_type= 'WCT_SECTION';

Line 95: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b

91: and b.section_type= 'WCT_SECTION';
92:
93: CURSOR c_line_location_wct_taxes(focus_id NUMBER) IS
94: SELECT a.tax_id
95: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b
96: WHERE line_focus_id = focus_id
97: and a.tax_id = b.tax_id
98: and b.section_type= 'WCT_SECTION'
99: AND a. tax_type = 'TDS';

Line 264: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct

260: PRAGMA AUTONOMOUS_TRANSACTION;
261: /* Cursor to get the localization taxes attached to the item line*/
262: Cursor get_loc_tax(cp_invoice_id number,cp_inv_distid number) is
263: select jm.*
264: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct
265: where jm.tax_id=jct.tax_id
266: and invoice_id = cp_invoice_id
267: and parent_invoice_distribution_id=cp_inv_distid
268: and line_type_lookup_code='MISCELLANEOUS'

Line 310: from jai_cmn_taxes_all

306:
307: cursor get_tax_name(cp_tax_id in number)
308: is
309: select tax_name
310: from jai_cmn_taxes_all
311: where tax_id=cp_tax_id;
312:
313:
314: cursor get_invoice_rate(cp_inv_id in number) is