APPS.IGF_SL_REL_DISB dependencies on HZ_PARTIES

Line 3336: l_person_id hz_parties.party_id%TYPE;

3332:
3333: TYPE cur_person_id_type IS REF CURSOR;
3334:
3335: cur_per_grp cur_person_id_type;
3336: l_person_id hz_parties.party_id%TYPE;
3337:
3338:
3339: -- Cursor to get alternate code for the calendar instance
3340: CURSOR cur_awdyear(cp_cal_type VARCHAR2, cp_seq_number NUMBER)

Line 3523: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN ('

3519: l_list := igf_ap_ss_pkg.get_pid(p_per_grp_id, l_status, lv_group_type);
3520:
3521: --Bug #5021084. Passing Group ID if the group type is STATIC.
3522: IF lv_group_type = 'STATIC' THEN
3523: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN ('
3524: || l_list || ') ' USING p_per_grp_id;
3525: ELSIF lv_group_type = 'DYNAMIC' THEN
3526: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN ('
3527: || l_list || ') ';

Line 3526: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN ('

3522: IF lv_group_type = 'STATIC' THEN
3523: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN ('
3524: || l_list || ') ' USING p_per_grp_id;
3525: ELSIF lv_group_type = 'DYNAMIC' THEN
3526: OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN ('
3527: || l_list || ') ';
3528: END IF;
3529:
3530: FETCH cur_per_grp INTO l_person_id;