DBA Data[Home] [Help]

APPS.EGO_ITEM_PEOPLE_IMPORT_PKG dependencies on MTL_PARAMETERS

Line 2547: FROM mtl_parameters mp

2543: AND ( (organization_id IS NOT NULL
2544: AND
2545: NOT EXISTS
2546: ( SELECT mp.organization_id
2547: FROM mtl_parameters mp
2548: WHERE mp.organization_id = eipi.organization_id
2549: )
2550: )
2551: OR

Line 2556: FROM mtl_parameters mp

2552: (organization_id IS NULL
2553: AND
2554: NOT EXISTS
2555: ( SELECT mp.organization_id
2556: FROM mtl_parameters mp
2557: WHERE mp.organization_code = eipi.organization_code
2558: )
2559: )
2560: );

Line 2565: FROM mtl_parameters mp

2561:
2562: UPDATE ego_item_people_intf eipi
2563: SET organization_code =
2564: ( SELECT mp.organization_code
2565: FROM mtl_parameters mp
2566: WHERE mp.organization_id = eipi.organization_id
2567: )
2568: WHERE eipi.data_set_id = G_DATA_SET_ID
2569: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER

Line 2576: FROM mtl_parameters mp

2572:
2573: UPDATE ego_item_people_intf eipi
2574: SET organization_id =
2575: ( SELECT mp.organization_id
2576: FROM mtl_parameters mp
2577: WHERE mp.organization_code = eipi.organization_code
2578: )
2579: WHERE eipi.data_set_id = G_DATA_SET_ID
2580: AND eipi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER