APPS.WSH_CAL_ASG_VALIDATIONS dependencies on PO_VENDORS

Line 1235: PO_VENDORS POV ,

1231: CURSOR c_get_calendar_code IS
1232: SELECT WCA.CALENDAR_CODE,
1233: WCA.ENABLED_FLAG
1234: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1235: PO_VENDORS POV ,
1236: PO_VENDOR_SITES_all POVS ,
1237: hr_organization_units HR
1238: WHERE WCA.ASSOCIATION_TYPE = 'VENDOR_SITE'
1239: AND WCA.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID

Line 1265: AND rel.object_table_name = 'PO_VENDORS'

1261: AND hps.party_site_id = hpsu.party_site_id
1262: AND hps.location_id = wl.wsh_location_id
1263: AND site_use_type = 'SUPPLIER_SHIP_FROM'
1264: AND rel.relationship_type = 'POS_VENDOR_PARTY'
1265: AND rel.object_table_name = 'PO_VENDORS'
1266: AND rel.object_type = 'POS_VENDOR'
1267: AND rel.subject_table_name = 'HZ_PARTIES'
1268: AND rel.subject_type = 'ORGANIZATION'
1269: ----