APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on HZ_CONTACT_POINTS

Line 639: FROM AS_SALES_LEADS SL, HZ_PARTIES PARTY, HZ_CONTACT_POINTS CNT

635: CNT.EMAIL_ADDRESS
636: -- ckapoor Phase 2 Filtering 11.5.10. Find the mode of caller
637: -- , SL.IMPORT_FLAG
638:
639: FROM AS_SALES_LEADS SL, HZ_PARTIES PARTY, HZ_CONTACT_POINTS CNT
640: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
641: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
642: AND SL.PRIMARY_CNT_PERSON_PARTY_ID = CNT.OWNER_TABLE_ID(+)
643: AND CNT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

Line 651: select phone_area_code from HZ_CONTACT_POINTS phone,

647: -- CURSOR C_Get_Area_Code(C_Customer_Id NUMBER, C_Address_Id NUMBER) IS
648:
649: CURSOR C_Get_Area_Code(C_Sales_Lead_ID NUMBER) IS
650:
651: select phone_area_code from HZ_CONTACT_POINTS phone,
652: as_sales_leads lead , hz_parties party
653: where
654: lead.sales_lead_id = C_Sales_Lead_ID
655: and ((lead.customer_id = party.party_id and party.party_type = 'PERSON'

Line 667: FROM hz_contact_points phon

663:
664: -- ckapoor 11.5.10 Change cursor sql to match sql_text for Area Code (changed in 11.5.10)
665: /*
666: SELECT phon.phone_area_code
667: FROM hz_contact_points phon
668: WHERE phon.owner_table_id = c_address_id
669: AND phon.owner_table_name = 'HZ_PARTY_SITES'
670: AND phon.contact_point_type = 'PHONE'
671: AND phon.status in ('A','I')

Line 674: FROM hz_contact_points phon

670: AND phon.contact_point_type = 'PHONE'
671: AND phon.status in ('A','I')
672: UNION ALL
673: SELECT phon.phone_area_code
674: FROM hz_contact_points phon
675: WHERE c_address_id IS NULL
676: AND phon.owner_table_id = c_customer_id
677: AND phon.owner_table_name = 'HZ_PARTIES'
678: AND phon.contact_point_type = 'PHONE'