APPS.IGF_SL_DL_ORIG dependencies on IGF_GR_GEN

Line 608: DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),10,0))

604: AND fabase.base_id = lv_base_id;
605:
606: -- Get the Student Phone
607: CURSOR cur_get_s_phone IS select
608: DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),10,0))
609: FROM DUAL;
610:
611: -- Get the Parent Phone
612: CURSOR cur_get_p_phone(p_per_id igf_ap_fa_base_rec.person_id%TYPE) IS