DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on DUAL

Line 1474: select 'Y' INTO l_category_exist FROM dual

1470: p_category_set_id IS NOT NULL AND
1471: p_category_id IS NOT NULL ) then
1472:
1473:
1474: select 'Y' INTO l_category_exist FROM dual
1475: where exists
1476: (select mic.category_id
1477: from mtl_item_categories mic
1478: where mic.organization_id = p_org_id

Line 1509: select 'Y' INTO l_group_class_exist FROM dual

1505: p_assignment_group_id IS NOT NULL AND
1506: p_class_id IS NOT NULL ) then
1507:
1508:
1509: select 'Y' INTO l_group_class_exist FROM dual
1510: where exists
1511: (select abc_class_id
1512: from mtl_abc_assignments
1513: where inventory_item_id = p_inventory_item_id