41: AND status_code = 'SUBMITTED'
42: AND end_date_active is null;
43: BEGIN
44:
45: l_opp_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_OPPORTUNITIES'),'OPEN'))));
46: l_lead_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_SALES_LEADS'),'OPEN'))));
47:
48: IF(Trigger_Mode = 'ON-INSERT') THEN
49:
42: AND end_date_active is null;
43: BEGIN
44:
45: l_opp_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_OPPORTUNITIES'),'OPEN'))));
46: l_lead_profile := upper(ltrim(rtrim(nvl(FND_PROFILE.Value('AS_MOVE_SALES_LEADS'),'OPEN'))));
47:
48: IF(Trigger_Mode = 'ON-INSERT') THEN
49:
50: IF(x_old_resource_id is null AND