APPS.HZ_EXTRACT_ORG_CONT_BO_PVT dependencies on HZ_PARTIES

Line 174: AND OWNER_TABLE_NAME = 'HZ_PARTIES'

170: ATTRIBUTE20)
171: FROM HZ_ORIG_SYS_REFERENCES OSR
172: WHERE
173: OSR.OWNER_TABLE_ID = PRO.PARTY_ID
174: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
175: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
176: HZ_EXT_ATTRIBUTE_OBJ_TBL())
177: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P
178: WHERE PRO.PARTY_ID = P.PARTY_ID AND P.PARTY_ID = P_PERSON_ID

Line 177: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P

173: OSR.OWNER_TABLE_ID = PRO.PARTY_ID
174: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
175: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
176: HZ_EXT_ATTRIBUTE_OBJ_TBL())
177: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P
178: WHERE PRO.PARTY_ID = P.PARTY_ID AND P.PARTY_ID = P_PERSON_ID
179: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);
180:
181: l_debug_prefix VARCHAR2(30) := '';

Line 585: FROM HZ_ORG_CONTACTS OC, HZ_PARTIES P, HZ_RELATIONSHIPS R

581: HZ_EMAIL_CP_BO_TBL(),
582: HZ_WEB_CP_BO_TBL(),
583: HZ_SMS_CP_BO_TBL(),
584: HZ_CONTACT_PREF_OBJ_TBL())
585: FROM HZ_ORG_CONTACTS OC, HZ_PARTIES P, HZ_RELATIONSHIPS R
586: WHERE OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
587: AND R.SUBJECT_ID = P.PARTY_ID
588: AND R.OBJECT_TYPE = 'PERSON'
589: AND ((P_ORG_CONTACT_ID IS NULL AND P.PARTY_ID = P_ORGANIZATION_ID)

Line 683: p_parent_table_name => 'HZ_PARTIES',

679: hz_extract_cont_point_bo_pvt.get_phone_bos
680: (p_init_msg_list => fnd_api.g_false,
681: p_phone_id => null,
682: p_parent_id => l_rel_party_id,
683: p_parent_table_name => 'HZ_PARTIES',
684: p_action_type => p_action_type,
685: x_phone_objs => x_org_contact_objs(i).phone_objs,
686: x_return_status => x_return_status,
687: x_msg_count => x_msg_count,

Line 699: p_parent_table_name => 'HZ_PARTIES',

695: hz_extract_cont_point_bo_pvt.get_email_bos
696: (p_init_msg_list => fnd_api.g_false,
697: p_email_id => null,
698: p_parent_id => l_rel_party_id,
699: p_parent_table_name => 'HZ_PARTIES',
700: p_action_type => p_action_type,
701: x_email_objs => x_org_contact_objs(i).email_objs,
702: x_return_status => x_return_status,
703: x_msg_count => x_msg_count,

Line 715: p_parent_table_name => 'HZ_PARTIES',

711: hz_extract_cont_point_bo_pvt.get_telex_bos
712: (p_init_msg_list => fnd_api.g_false,
713: p_telex_id => null,
714: p_parent_id => l_rel_party_id,
715: p_parent_table_name => 'HZ_PARTIES',
716: x_telex_objs => x_org_contact_objs(i).telex_objs,
717: x_return_status => x_return_status,
718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);

Line 730: p_parent_table_name => 'HZ_PARTIES',

726: hz_extract_cont_point_bo_pvt.get_web_bos
727: (p_init_msg_list => fnd_api.g_false,
728: p_web_id => null,
729: p_parent_id => l_rel_party_id,
730: p_parent_table_name => 'HZ_PARTIES',
731: p_action_type => p_action_type,
732: x_web_objs => x_org_contact_objs(i).web_objs,
733: x_return_status => x_return_status,
734: x_msg_count => x_msg_count,

Line 746: p_parent_table_name => 'HZ_PARTIES',

742: hz_extract_cont_point_bo_pvt.get_sms_bos
743: (p_init_msg_list => fnd_api.g_false,
744: p_sms_id => null,
745: p_parent_id => l_rel_party_id,
746: p_parent_table_name => 'HZ_PARTIES',
747: p_action_type => p_action_type,
748: x_sms_objs => x_org_contact_objs(i).sms_objs,
749: x_return_status => x_return_status,
750: x_msg_count => x_msg_count,

Line 761: p_cont_level_table => 'HZ_PARTIES',

757:
758: hz_extract_cont_point_bo_pvt.get_cont_pref_objs
759: (p_init_msg_list => fnd_api.g_false,
760: p_cont_level_table_id => l_rel_party_id,
761: p_cont_level_table => 'HZ_PARTIES',
762: p_contact_type => NULL,
763: p_action_type => p_action_type,
764: x_cont_pref_objs => x_org_contact_objs(i).contact_pref_objs,
765: x_return_status => x_return_status,