APPS.IGF_SL_DL_ORIG dependencies on DUAL

Line 233: --Used UNION ALL here since individual select clauses

229: loan.loan_status = 'V' AND -- "Valid and Ready to Send"
230: loan.active = 'Y';
231:
232: --Cursor to fetch the Meaning for displaying parameters passed
233: --Used UNION ALL here since individual select clauses
234: --have the same cost
235: --Bug 2332668
236:
237: CURSOR cur_get_parameters IS

Line 609: FROM DUAL;

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
613: SELECT DECODE(igf_sl_gen.get_person_phone(p_per_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(p_per_id),10,0))

Line 614: 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
613: SELECT DECODE(igf_sl_gen.get_person_phone(p_per_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(p_per_id),10,0))
614: FROM DUAL;
615:
616: l_p_phone VARCHAR2(80);
617: l_s_phone VARCHAR2(80);
618: