APPS.CSM_MULTI_MOBQRY_PKG dependencies on HZ_PARTY_SITES

Line 1151: FROM hz_cust_acct_sites_all a, hz_party_sites b,jtf_tasks_b t,cs_incidents_all_b i

1147: CSM_UTIL_PKG.LOG('Creating new loc as No HR Location found for party site id:'||p_party_site_id, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1148:
1149: SELECT a.cust_account_id ,b.party_id,b.location_id,a.org_id
1150: INTO l_account_id,l_party_id,x_loc_id,l_org_id
1151: FROM hz_cust_acct_sites_all a, hz_party_sites b,jtf_tasks_b t,cs_incidents_all_b i
1152: WHERE b.PARTY_SITE_ID=a.PARTY_SITE_ID
1153: AND t.task_id=p_task_id
1154: and t.sourcE_object_type_code='SR'
1155: and i.customer_id=b.party_id

Line 1361: from po_location_associations_all a, HZ_CUST_ACCT_SITES_ALL b ,hz_party_sites c

1357: l_hr_loc_id:=x_loc_id;
1358:
1359: select b.party_site_id,c.location_id ,a.address_id,a.org_id
1360: into l_hz_psite_id,l_hz_loc_id,l_cust_acct_site_id,l_org_id
1361: from po_location_associations_all a, HZ_CUST_ACCT_SITES_ALL b ,hz_party_sites c
1362: where a.location_id=x_loc_id
1363: and b.cust_account_id=x_cust_id
1364: and a.address_id=b.cust_acct_site_id
1365: and b.party_site_id=c.party_site_id;