APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on AP_SUPPLIERS

Line 3: PROCEDURE main(p_vendor_id IN ap_suppliers.vendor_id%TYPE

1: PACKAGE BODY igi_cis2007_tax_eff_date AS
2: -- $Header: igiefdtb.pls 120.1.12010000.2 2008/12/19 12:58:32 gaprasad ship $
3: PROCEDURE main(p_vendor_id IN ap_suppliers.vendor_id%TYPE
4: , p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%TYPE
5: , p_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE
6: , p_pay_tax_grp_id IN ap_awt_group_taxes_all.group_id%TYPE /* Bug 7218825 */
7: , p_source IN VARCHAR2

Line 15: CURSOR c_vendor_sites(p_vendor_id ap_suppliers.vendor_id%TYPE

11: -- to get all the vendor site of a vendor
12: -- when the vendor is null it fetches all the vendor's sites
13: -- check for the vendor to be cis_enabled = 'y'
14: -- and the vendor_site has allow_awt_flag = 'y'
15: CURSOR c_vendor_sites(p_vendor_id ap_suppliers.vendor_id%TYPE
16: , p_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE) IS
17: SELECT pov.vendor_id,
18: povs.vendor_site_id,
19: povs.org_id

Line 21: ap_suppliers pov

17: SELECT pov.vendor_id,
18: povs.vendor_site_id,
19: povs.org_id
20: FROM ap_supplier_sites_all povs,
21: ap_suppliers pov
22: WHERE pov.vendor_id = p_vendor_id
23: AND pov.vendor_id = povs.vendor_id
24: AND povs.vendor_site_id = nvl(p_vendor_site_id, povs.vendor_site_id)
25: AND pov.cis_enabled_flag = 'Y'

Line 50: CURSOR c_tax_names(p_vendor_id ap_suppliers.vendor_id%TYPE

46: AND atr.org_id = p_org_id
47: ORDER BY agt.group_id,
48: atr.tax_rate;
49:
50: CURSOR c_tax_names(p_vendor_id ap_suppliers.vendor_id%TYPE
51: , p_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE
52: , p_org_id ap_supplier_sites_all.org_id%TYPE) IS
53: SELECT DISTINCT tax_name
54: FROM ap_awt_tax_rates_all

Line 119: FROM ap_suppliers po,

115: , 'VENDOR FORM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
116: , 'CDROM', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id)
117: , 'VERIFY', IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po.vendor_id,NULL,po.awt_group_id,po.pay_awt_group_id))
118: INTO l_old_tax_grp_id
119: FROM ap_suppliers po,
120: ap_supplier_sites_all po_site
121: WHERE po.vendor_id = p_vendor_id
122: AND po_site.vendor_id = po.vendor_id
123: AND po_site.allow_awt_flag = 'Y'

Line 136: FROM ap_suppliers po,

132: --Fetch the old tax group id for the vendor site
133: BEGIN
134: SELECT IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(po_site.vendor_id,po_site.vendor_site_id, po_site.awt_group_id, po_site.pay_awt_group_id)
135: INTO l_site_old_tax_grp_id
136: FROM ap_suppliers po,
137: ap_supplier_sites_all po_site
138: WHERE po.vendor_id = p_vendor_id
139: AND po_site.vendor_id = po.vendor_id
140: AND po_site.allow_awt_flag = 'Y'