APPS.IGF_SP_CREATE_BASE_REC dependencies on HZ_PARTIES

Line 123: l_person_id hz_parties.party_id%TYPE;

119: l_v_message_name fnd_new_messages.message_name%TYPE;
120:
121: TYPE RefCur IS REF CURSOR;
122: c_person_id RefCur;
123: l_person_id hz_parties.party_id%TYPE;
124: lv_status VARCHAR2(1);
125: l_list VARCHAR2(32767);
126: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
127:

Line 310: OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_person_group_id;

306: l_list := igf_ap_ss_pkg.get_pid(p_person_group_id,lv_status,lv_group_type);
307:
308: --Bug #5021084. Passing Group ID if the group type is STATIC.
309: IF lv_group_type = 'STATIC' THEN
310: OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_person_group_id;
311: ELSIF lv_group_type = 'DYNAMIC' THEN
312: OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';
313: END IF;
314:

Line 312: OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';

308: --Bug #5021084. Passing Group ID if the group type is STATIC.
309: IF lv_group_type = 'STATIC' THEN
310: OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_person_group_id;
311: ELSIF lv_group_type = 'DYNAMIC' THEN
312: OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';
313: END IF;
314:
315: LOOP
316: