APPS.ZX_UPGRADE_CONTROL_PKG dependencies on AP_SUPPLIERS

Line 302: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP

298: P_bank_charge_bearer IN VARCHAR2) IS
299:
300: CURSOR C_SUPPLIER_TYPE IS
301: SELECT POV.VENDOR_ID
302: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP
303: WHERE POV.VENDOR_ID = PTP.PARTY_ID
304: AND POV.VENDOR_ID = p_vendor_id
305: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
306: AND VENDOR_TYPE_LOOKUP_CODE is not null

Line 799: FROM ap_suppliers Pv

795: ,SYSDATE -- Who Columns
796: ,fnd_global.user_id -- Who Columns
797: ,SYSDATE -- Who Columns
798: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
799: FROM ap_suppliers Pv
800: WHERE p_Vendor_Site_Id = nvl(P_vendor_site_Id,p_Vendor_site_Id)
801: AND p_vendor_id = pv.vendor_id
802: AND pv.VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
803:

Line 861: FROM ap_suppliers PV,

857: ,SYSDATE
858: ,fnd_global.user_id
859: ,SYSDATE
860: ,FND_GLOBAL.CONC_LOGIN_ID
861: FROM ap_suppliers PV,
862: zx_party_tax_profile PTP
863: WHERE
864: P_vendor_site_id = PTP.Party_ID
865: AND PTP.Party_Type_code = 'SUPPLIER_SITE'

Line 1008: ap_suppliers PV,

1004: ,fnd_global.user_id
1005: ,SYSDATE
1006: ,FND_GLOBAL.CONC_LOGIN_ID
1007: FROM ap_supplier_sites_all PVS,
1008: ap_suppliers PV,
1009: zx_party_tax_profile PTP
1010: WHERE p_vendor_site_id = PTP.Party_ID
1011: AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1012: AND p_Vendor_ID = PV.Vendor_ID);

Line 1073: FROM ap_suppliers PV,

1069: ,SYSDATE
1070: ,fnd_global.user_id
1071: ,SYSDATE
1072: ,FND_GLOBAL.CONC_LOGIN_ID
1073: FROM ap_suppliers PV,
1074: zx_party_tax_profile PTP
1075: WHERE p_vendor_site_id = PTP.Party_ID
1076: AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1077: AND p_Vendor_ID = PV.Vendor_ID;

Line 1138: ap_suppliers PV,

1134: ,fnd_global.user_id
1135: ,SYSDATE
1136: ,FND_GLOBAL.CONC_LOGIN_ID
1137: FROM ap_supplier_sites_all PVS,
1138: ap_suppliers PV,
1139: zx_party_tax_profile PTP
1140: WHERE p_vendor_site_id = PTP.Party_ID
1141: AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1142: AND p_Vendor_ID = PV.Vendor_ID);

Line 1170: FROM ap_suppliers

1166: Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1167: WHERE party_tax_profile_id= p_VENDOR_SITE_ID
1168: and party_TYPE_CODE = 'SUPPLIER_SITE'
1169: and p_vendor_id in ( SELECT vendor_id
1170: FROM ap_suppliers
1171: WHERE p_vendor_id = p_vendor_id
1172: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY' );
1173:
1174:

Line 1177: FROM ap_suppliers

1173:
1174:
1175: SELECT global_attribute10,global_attribute11,global_attribute12,global_attribute13,global_attribute14
1176: INTO l_global_attribute10,l_global_attribute11,l_global_attribute12,l_global_attribute13,l_global_attribute14
1177: FROM ap_suppliers
1178: WHERE vendor_id=p_Vendor_id;
1179:
1180:
1181: UPDATE ZX_REGISTRATIONS