APPS.OKC_TERMS_MIGRATE_GRP dependencies on HZ_PARTIES

Line 4083: SELECT 'Y' FROM hz_parties WHERE party_id = p_party_contact_id;

4079: WHERE organization_id = p_party_id;
4080:
4081: CURSOR cur_val_ext_party_contact_id (p_party_contact_id number)
4082: IS
4083: SELECT 'Y' FROM hz_parties WHERE party_id = p_party_contact_id;
4084:
4085: l_val_flag VARCHAR2(1);
4086:
4087: l_party_name VARCHAR2(240);