APPS.WSH_CAL_ASG_VALIDATIONS dependencies on PO_VENDORS

Line 1056: PO_VENDORS POV ,

1052: CURSOR c_get_calendar_code IS
1053: SELECT WCA.CALENDAR_CODE,
1054: WCA.ENABLED_FLAG
1055: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1056: PO_VENDORS POV ,
1057: PO_VENDOR_SITES_all POVS ,
1058: hr_organization_units HR
1059: WHERE WCA.ASSOCIATION_TYPE = 'VENDOR_SITE'
1060: AND WCA.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID

Line 1086: AND rel.object_table_name = 'PO_VENDORS'

1082: AND hps.party_site_id = hpsu.party_site_id
1083: AND hps.location_id = wl.wsh_location_id
1084: AND site_use_type = 'SUPPLIER_SHIP_FROM'
1085: AND rel.relationship_type = 'POS_VENDOR_PARTY'
1086: AND rel.object_table_name = 'PO_VENDORS'
1087: AND rel.object_type = 'POS_VENDOR'
1088: AND rel.subject_table_name = 'HZ_PARTIES'
1089: AND rel.subject_type = 'ORGANIZATION'
1090: ----