APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_PE_PERSON

Line 144: FUNCTION get_rfnd_hold (p_person_id igs_pe_person.person_id%TYPE) RETURN BOOLEAN IS

140: CLOSE cur_ftyp_no_ftci;
141: END IF;
142: END get_fee_prd;
143:
144: FUNCTION get_rfnd_hold (p_person_id igs_pe_person.person_id%TYPE) RETURN BOOLEAN IS
145: /*************************************************************
146: Created By : vchappid
147: Date Created By : 01-Mar-2002
148: Purpose : Function to determine whether a person is having active STOPREFUND hold effects hold

Line 155: CURSOR cur_hold_check (cp_person_id igs_pe_person.person_id%TYPE)

151: Who When What
152: (reverse chronological order - newest change first)
153: ***************************************************************/
154:
155: CURSOR cur_hold_check (cp_person_id igs_pe_person.person_id%TYPE)
156: IS
157: SELECT 'X'
158: FROM igs_pe_persenc_effct
159: WHERE person_id = cp_person_id