APPS.IGF_DB_DISB dependencies on HZ_PARTIES

Line 3674: l_person_id hz_parties.party_id%TYPE;

3670: lv_status VARCHAR2(1);
3671: TYPE cur_person_id_type IS REF CURSOR;
3672: cur_per_grp cur_person_id_type;
3673:
3674: l_person_id hz_parties.party_id%TYPE;
3675: lv_profile_value VARCHAR2(30);
3676: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
3677: BEGIN
3678:

Line 3769: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_per_grp_id;

3765: l_list := igf_ap_ss_pkg.get_pid(p_per_grp_id,lv_status,lv_group_type);
3766:
3767: --Bug #5021084. Passing Group ID if the group type is STATIC.
3768: IF lv_group_type = 'STATIC' THEN
3769: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_per_grp_id;
3770: ELSIF lv_group_type = 'DYNAMIC' THEN
3771: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';
3772: END IF;
3773:

Line 3771: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';

3767: --Bug #5021084. Passing Group ID if the group type is STATIC.
3768: IF lv_group_type = 'STATIC' THEN
3769: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_per_grp_id;
3770: ELSIF lv_group_type = 'DYNAMIC' THEN
3771: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';
3772: END IF;
3773:
3774: FETCH cur_per_grp INTO l_person_id;
3775: