DBA Data[Home] [Help]

APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on MTL_PARAMETERS

Line 2275: FROM mtl_parameters mp

2271: AND ( (organization_id IS NOT NULL
2272: AND
2273: NOT EXISTS
2274: ( SELECT mp.organization_id
2275: FROM mtl_parameters mp
2276: WHERE mp.organization_id = eipi.organization_id
2277: )
2278: )
2279: OR

Line 2284: FROM mtl_parameters mp

2280: (organization_id IS NULL
2281: AND
2282: NOT EXISTS
2283: ( SELECT mp.organization_id
2284: FROM mtl_parameters mp
2285: WHERE mp.organization_code = eipi.organization_code
2286: )
2287: )
2288: );

Line 2293: FROM mtl_parameters mp

2289:
2290: UPDATE ego_item_people_intf eipi
2291: SET organization_code =
2292: ( SELECT mp.organization_code
2293: FROM mtl_parameters mp
2294: WHERE mp.organization_id = eipi.organization_id
2295: )
2296: WHERE eipi.data_set_id = G_DATA_SET_ID
2297: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER

Line 2304: FROM mtl_parameters mp

2300:
2301: UPDATE ego_item_people_intf eipi
2302: SET organization_id =
2303: ( SELECT mp.organization_id
2304: FROM mtl_parameters mp
2305: WHERE mp.organization_code = eipi.organization_code
2306: )
2307: WHERE eipi.data_set_id = G_DATA_SET_ID
2308: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER