297: SL.SOURCE_PROMOTION_ID,
298: TO_NUMBER(NULL)
299: FROM AS_SALES_LEADS SL,
300: HZ_CONTACT_POINTS PHONE,
301: HZ_LOCATIONS ADDR,
302: HZ_PARTY_SITES SITE,
303: HZ_PARTIES PARTY
304: WHERE SL.SALES_LEAD_ID = X_Sales_Lead_Id
305: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
942: UPPER(PARTY.DUNS_NUMBER_C),
943: UPPER(SL.CHANNEL_CODE)
944: FROM AS_SALES_LEADS SL,
945: HZ_CONTACT_POINTS PHONE,
946: HZ_LOCATIONS ADDR,
947: HZ_PARTY_SITES SITE,
948: HZ_PARTIES PARTY,
949: HZ_ORGANIZATION_PROFILES ORGP
950: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
2066: UPPER(PARTY.DUNS_NUMBER_C),
2067: UPPER(SL.CHANNEL_CODE)
2068: FROM AS_SALES_LEADS SL,
2069: HZ_CONTACT_POINTS PHONE,
2070: HZ_LOCATIONS ADDR,
2071: HZ_PARTY_SITES SITE,
2072: HZ_PARTIES PARTY,
2073: HZ_ORGANIZATION_PROFILES ORGP
2074: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id