APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_PARTIES

Line 389: FROM HZ_PARTIES

385: x_party_merge_objs OUT NOCOPY CRMINTEG_HZ_MERGE_OBJ_TBL
386: ) IS
387: CURSOR get_merge_type IS
388: SELECT party_type
389: FROM HZ_PARTIES
390: WHERE party_id = p_merge_to_party_id;
391:
392: CURSOR get_merge_parties(l_batch_id NUMBER) IS
393: SELECT p.party_type, from_parent_entity_id, from_entity_id, to_parent_entity_id

Line 394: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph, HZ_MERGE_DICTIONARY md, HZ_PARTIES p

390: WHERE party_id = p_merge_to_party_id;
391:
392: CURSOR get_merge_parties(l_batch_id NUMBER) IS
393: SELECT p.party_type, from_parent_entity_id, from_entity_id, to_parent_entity_id
394: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph, HZ_MERGE_DICTIONARY md, HZ_PARTIES p
395: where mb.batch_id = l_batch_id
396: and mb.batch_id = mp.batch_id
397: and mp.batch_party_id = mph.batch_party_id
398: and mph.merge_dict_id = md.merge_dict_id

Line 581: WHERE owner_table_name = 'HZ_PARTIES'

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';
585:

Line 589: WHERE cp.owner_table_name = 'HZ_PARTIES'

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'
593: AND oc.org_contact_id = l_oc_id

Line 772: WHERE owner_table_name = 'HZ_PARTIES'

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';
776:

Line 780: WHERE cp.owner_table_name = 'HZ_PARTIES'

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'
784: AND oc.org_contact_id = l_oc_id

Line 941: UPDATE HZ_PARTIES

937: l_org_cust_bo.organization_obj := l_org_obj;
938: l_org_cust_bo.account_objs.EXTEND;
939: l_org_cust_bo.account_objs(1) := l_input_acct_obj;
940:
941: UPDATE HZ_PARTIES
942: set ORG_CUST_BO_VERSION = ( SELECT BO_VERSION_NUMBER
943: FROM HZ_BUS_OBJ_DEFINITIONS
944: WHERE BUSINESS_OBJECT_CODE = 'ORG_CUST'
945: AND ENTITY_NAME = 'HZ_PARTIES'

Line 945: AND ENTITY_NAME = 'HZ_PARTIES'

941: UPDATE HZ_PARTIES
942: set ORG_CUST_BO_VERSION = ( SELECT BO_VERSION_NUMBER
943: FROM HZ_BUS_OBJ_DEFINITIONS
944: WHERE BUSINESS_OBJECT_CODE = 'ORG_CUST'
945: AND ENTITY_NAME = 'HZ_PARTIES'
946: AND CHILD_BO_CODE IS NULL )
947: WHERE party_id = l_organization_id;
948:
949: -- call save_org_cust_bo