APPS.PON_ATTR_MAPPING dependencies on AP_SUPPLIER_SITES_ALL

Line 56: FROM ap_supplier_sites_all

52: AND hzpsu.party_site_id = hzps.party_site_id
53: AND hzpsu.status = 'A'
54: UNION
55: SELECT 'AP:PURCHASING' as code
56: FROM ap_supplier_sites_all
57: WHERE vendor_id = x_vendor_id
58: AND purchasing_site_flag = 'Y'
59: UNION
60: SELECT 'AP:PAY'

Line 61: FROM ap_supplier_sites_all

57: WHERE vendor_id = x_vendor_id
58: AND purchasing_site_flag = 'Y'
59: UNION
60: SELECT 'AP:PAY'
61: FROM ap_supplier_sites_all
62: WHERE vendor_id = x_vendor_id
63: AND pay_site_flag = 'Y'
64: UNION
65: SELECT 'AP:PRIMARY_PAY'

Line 66: FROM ap_supplier_sites_all

62: WHERE vendor_id = x_vendor_id
63: AND pay_site_flag = 'Y'
64: UNION
65: SELECT 'AP:PRIMARY_PAY'
66: FROM ap_supplier_sites_all
67: WHERE vendor_id = x_vendor_id
68: AND primary_pay_site_flag = 'Y'
69: UNION
70: SELECT 'AP:RFQ'

Line 71: FROM ap_supplier_sites_all

67: WHERE vendor_id = x_vendor_id
68: AND primary_pay_site_flag = 'Y'
69: UNION
70: SELECT 'AP:RFQ'
71: FROM ap_supplier_sites_all
72: WHERE vendor_id = x_vendor_id
73: AND rfq_only_site_flag = 'Y'
74: UNION
75: SELECT 'AP:PCARD'

Line 76: FROM ap_supplier_sites_all

72: WHERE vendor_id = x_vendor_id
73: AND rfq_only_site_flag = 'Y'
74: UNION
75: SELECT 'AP:PCARD'
76: FROM ap_supplier_sites_all
77: WHERE vendor_id = x_vendor_id
78: AND pcard_site_flag = 'Y';
79:
80: CURSOR ps_cursor(x_vendor_id NUMBER)