528:
529: UPDATE bim_i_lead_facts_stg stg SET CUSTOMER_FLAG='Y'
530: WHERE
531: EXISTS
532: (SELECT 1 from HZ_CUST_ACCOUNTS a,hz_parties b
533: WHERE a.party_id=stg.customer_id
534: AND stg.lead_creation_date >= trunc(a.creation_date)
535: AND a.party_id=b.party_id
536: AND b.certification_level is not null);
539:
540: UPDATE bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'
541: WHERE
542: EXISTS
543: (SELECT 1 from HZ_CUST_ACCOUNTS a
544: WHERE a.party_id=stg.customer_id
545: AND stg.lead_creation_date >= trunc(a.creation_date)
546: );
547:
1125:
1126: update bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'
1127: where
1128: exists
1129: (select 1 from HZ_CUST_ACCOUNTS a,hz_parties b
1130: where a.party_id=stg.customer_id
1131: and stg.lead_creation_date >= trunc(a.creation_date)
1132: and a.party_id=b.party_id
1133: and b.certification_level is not null);
1136:
1137: update bim_i_lead_facts_stg stg set CUSTOMER_FLAG='Y'
1138: where
1139: exists
1140: (select 1 from HZ_CUST_ACCOUNTS a
1141: where a.party_id=stg.customer_id
1142: and stg.lead_creation_date >= trunc(a.creation_date));
1143:
1144: end if;