DBA Data[Home] [Help]

APPS.IGF_AW_CANCEL_AWD dependencies on IGS_PE_PERSON_BASE_V

Line 120: p_per_num OUT NOCOPY igs_pe_person_base_v.person_number%TYPE

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
121: )
122: IS
123: /*
124: || Created By : museshad

Line 137: FROM igs_pe_person_base_v

133:
134: CURSOR cur_get_pers_num (cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
135: IS
136: SELECT person_number
137: FROM igs_pe_person_base_v
138: WHERE person_id = cp_person_id;
139:
140: CURSOR cur_get_base (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
141: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,