1477: BEGIN
1478: if(default_type is not null) then
1479: select lookup_code
1480: into default_type_code 1481: from fnd_lookup_values l 1482: where l.lookup_type = 'FLEX_DEFAULT_TYPE'
1483: and l.enabled_flag = 'Y'
1484: and sysdate between nvl(l.start_date_active, Sysdate)
1485: and nvl(l.end_date_active, Sysdate)