APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 50: , jai_cmn_taxes_all jcta

46:
47: CURSOR get_tax_type_cur IS
48: SELECT jcta.tax_type
49: FROM jai_cmn_document_taxes jcdt
50: , jai_cmn_taxes_all jcta
51: , jai_ap_invoice_lines jail
52: , jai_rgm_registrations jrr
53: , jai_rgm_definitions jrd
54: WHERE jcdt.source_doc_id = pr_new.invoice_id

Line 68: , jai_cmn_taxes_all jcta

64:
65: CURSOR get_matched_tax_cur IS
66: SELECT jcta.tax_type
67: FROM jai_ap_match_inv_taxes jamt
68: , jai_cmn_taxes_all jcta
69: , jai_rgm_registrations jrr
70: , jai_rgm_definitions jrd
71: WHERE jamt.invoice_id = pr_new.invoice_id
72: AND jamt.invoice_line_number = pr_new.invoice_line_number

Line 893: ln_final_tds_tax_id JAI_CMN_TAXES_ALL.tax_id%type;

889: PROCEDURE BRIUD_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
890: lv_final_dff_value_tds varchar2(150);
891: lv_process_flag varchar2(20);
892: lv_process_message varchar2(200);
893: ln_final_tds_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
894:
895: cursor c_ap_invoices_all is
896: select ai.vendor_id,
897: ai.vendor_site_id,

Line 964: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

960: AND trunc (p_inv_date) between start_date and end_date ; -- Modified by Jia for FP Bug#8656402, change sysdate to p_inv_date
961: /*START, by amandali for Bug#10430662*/
962: cursor c_receipt_wct_tax(p_shipment_line_id number) is
963: select a.tax_id
964: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
965: where a.tax_id = b.tax_id
966: and a.shipment_line_id = p_shipment_line_id
967: and a.tax_type = 'TDS'
968: and b.section_type= 'WCT_SECTION';

Line 972: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b

968: and b.section_type= 'WCT_SECTION';
969:
970: CURSOR c_line_location_wct_taxes(focus_id NUMBER) IS
971: SELECT a.tax_id
972: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b
973: WHERE line_focus_id = focus_id
974: and a.tax_id = b.tax_id
975: and b.section_type= 'WCT_SECTION'
976: AND a. tax_type = 'TDS';

Line 1131: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct

1127: PRAGMA AUTONOMOUS_TRANSACTION;
1128: /* Cursor to get the localization taxes attached to the item line*/
1129: Cursor get_loc_tax(cp_invoice_id number,cp_inv_distid number) is
1130: select jm.*
1131: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct
1132: where jm.tax_id=jct.tax_id
1133: and invoice_id = cp_invoice_id
1134: and parent_invoice_distribution_id=cp_inv_distid
1135: and line_type_lookup_code='MISCELLANEOUS'

Line 1177: from jai_cmn_taxes_all

1173:
1174: cursor get_tax_name(cp_tax_id in number)
1175: is
1176: select tax_name
1177: from jai_cmn_taxes_all
1178: where tax_id=cp_tax_id;
1179:
1180:
1181: cursor get_invoice_rate(cp_inv_id in number) is