DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on CS_INCIDENTS_ALL_B

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