APPS.IGF_AW_CANCEL_AWD dependencies on HZ_PARTIES

Line 116: p_person_id IN hz_parties.party_id%TYPE,

112: RETURN l_result;
113: END chk_awd_exp_date;
114:
115: PROCEDURE get_base_id_per_num (
116: p_person_id IN hz_parties.party_id%TYPE,
117: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
118: p_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
119: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
120: p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE

Line 499: l_party_id hz_parties.party_id%TYPE;

495: l_ci_cal_type igf_aw_award_v.ci_cal_type%TYPE;
496: l_ci_sequence_number igf_aw_award_v.ci_sequence_number%TYPE;
497: l_year VARCHAR2(80) DEFAULT igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
498: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
499: l_party_id hz_parties.party_id%TYPE;
500: l_per_exists BOOLEAN := FALSE;
501: l_list VARCHAR2(32767);
502: l_status VARCHAR2(1);
503: l_pig_desc igs_pe_persid_group_all.description%TYPE;

Line 661: OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pig;

657: l_per_exists := FALSE;
658:
659: --Bug #5021084. Passing Group ID if the group type is STATIC.
660: IF lv_group_type = 'STATIC' THEN
661: OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pig;
662: ELSIF lv_group_type = 'DYNAMIC' THEN
663: OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
664: END IF;
665:

Line 663: OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';

659: --Bug #5021084. Passing Group ID if the group type is STATIC.
660: IF lv_group_type = 'STATIC' THEN
661: OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pig;
662: ELSIF lv_group_type = 'DYNAMIC' THEN
663: OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
664: END IF;
665:
666: LOOP
667: FETCH l_per_cur INTO l_party_id;