APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_CONTACT_POINTS

Line 580: FROM HZ_CONTACT_POINTS

576: l_org_cust_bo HZ_ORG_CUST_BO;
577:
578: CURSOR get_cp_id(l_org_id NUMBER) IS
579: SELECT contact_point_id
580: FROM HZ_CONTACT_POINTS
581: WHERE owner_table_name = 'HZ_PARTIES'
582: AND contact_point_type = 'WEB'
583: AND owner_table_id = l_org_id
584: AND primary_flag = 'Y';

Line 588: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp

584: AND primary_flag = 'Y';
585:
586: CURSOR get_occp_id(l_oc_id NUMBER) IS
587: SELECT cp.contact_point_id
588: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp
589: WHERE cp.owner_table_name = 'HZ_PARTIES'
590: AND cp.contact_point_type = 'EMAIL'
591: AND cp.owner_table_id = r.party_id
592: AND cp.primary_flag = 'Y'

Line 771: FROM HZ_CONTACT_POINTS

767: l_return_obj HZ_ORG_CUST_BO;
768:
769: CURSOR get_cp_id(l_org_id NUMBER) IS
770: SELECT contact_point_id
771: FROM HZ_CONTACT_POINTS
772: WHERE owner_table_name = 'HZ_PARTIES'
773: AND contact_point_type = 'WEB'
774: AND owner_table_id = l_org_id
775: AND primary_flag = 'Y';

Line 779: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp

775: AND primary_flag = 'Y';
776:
777: CURSOR get_occp_id(l_oc_id NUMBER) IS
778: SELECT cp.contact_point_id
779: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp
780: WHERE cp.owner_table_name = 'HZ_PARTIES'
781: AND cp.contact_point_type = 'EMAIL'
782: AND cp.owner_table_id = r.party_id
783: AND cp.primary_flag = 'Y'