DBA Data[Home] [Help]

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1090: hz_cust_acct_sites_all hcas

1086: CURSOR c_get_customer(c_location_id IN NUMBER) IS
1087: SELECT hcas.cust_account_id
1088: FROM wsh_locations wl,
1089: hz_party_sites hps,
1090: hz_cust_acct_sites_all hcas
1091: WHERE wl.wsh_location_id = c_location_id
1092: AND wl.location_source_code = 'HZ'
1093: AND wl.source_location_id = hps.location_id
1094: AND hps.party_site_id = hcas.party_site_id;