APPS.EGO_ITEM_AML_PVT dependencies on MTL_PARAMETERS

Line 439: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp

435: WHERE data_set_id = p_data_set_id
436: AND process_flag = G_PS_IN_PROCESS
437: AND ( (organization_id IS NOT NULL
438: AND
439: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp
440: WHERE mp.organization_id = aml_intf.organization_id)
441: )
442: OR
443: (organization_id IS NULL

Line 445: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp

441: )
442: OR
443: (organization_id IS NULL
444: AND
445: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp
446: WHERE mp.organization_code = aml_intf.organization_code)
447: )
448: );
449:

Line 456: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp

452: WHERE data_set_id = p_data_set_id
453: AND process_flag = G_PS_IN_PROCESS
454: AND ( (organization_id IS NOT NULL
455: AND
456: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp
457: WHERE mp.organization_id = aml_intf.organization_id
458: AND mp.organization_id = mp.master_organization_id)
459: )
460: OR

Line 463: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp

459: )
460: OR
461: (organization_id IS NULL
462: AND
463: NOT EXISTS (SELECT 'x' FROM mtl_parameters mp
464: WHERE mp.organization_code = aml_intf.organization_code
465: AND mp.organization_id = mp.master_organization_id)
466: )
467: );

Line 472: from mtl_parameters mp

468:
469: UPDATE ego_aml_intf aml_intf
470: SET organization_id =
471: (Select organization_id
472: from mtl_parameters mp
473: where mp.organization_code = aml_intf.organization_code)
474: WHERE data_set_id = p_data_set_id
475: AND process_flag = G_PS_IN_PROCESS
476: AND organization_id IS NULL;

Line 2073: from mtl_parameters mp

2069:
2070: UPDATE ego_aml_intf aml_intf
2071: SET organization_code =
2072: (Select organization_code
2073: from mtl_parameters mp
2074: where mp.organization_id = aml_intf.organization_id)
2075: WHERE data_set_id = p_data_set_id
2076: AND organization_id IS NOT NULL
2077: AND process_flag IN (G_PS_ITEM_ERR