APPS.IGF_SL_DL_RECORD dependencies on DUAL

Line 131: ||RPAD(' ',(p_rec_length-80)) h_record FROM DUAL;

127: ||RPAD(' ', 2)
128: ||RPAD(' ', 8)
129: ||RPAD(' ',2)
130: ||RPAD('IGS1157',9)
131: ||RPAD(' ',(p_rec_length-80)) h_record FROM DUAL;
132:
133: igf_sl_dl_batch_pkg.insert_row (
134: x_mode => 'R',
135: x_rowid => lv_rowid,

Line 214: RPAD(' ',(p_rec_length-80)) t_record FROM DUAL;

210: RPAD(' ', 5)||
211: RPAD(' ', 5)||
212: RPAD(' ', 5)||
213: RPAD(' ',44)||
214: RPAD(' ',(p_rec_length-80)) t_record FROM DUAL;
215: END IF;
216:
217: EXCEPTION
218: WHEN OTHERS THEN

Line 667: FROM dual;

663: 'N',' ',
664: l_lor_details.disclosure_print_ind) ,' '),1)
665: ||RPAD(NVL(student_dtl_rec.p_email_addr,' '),50) -- #149
666: transaction_rec
667: FROM dual;
668:
669: ELSIF p_dl_loan_catg = 'DL_PLUS' THEN
670:
671: OPEN Orig_Rec FOR

Line 725: FROM dual;

721: 'N',' ',
722: l_lor_details.disclosure_print_ind) ,' '),1)
723: ||RPAD(NVL(student_dtl_rec.p_email_addr,' '),50) -- #149
724: transaction_rec
725: FROM dual;
726:
727: END IF;
728:
729: ELSIF p_dl_version IN ('2003-2004','2004-2005') THEN

Line 790: FROM dual;

786: 'N',' ',
787: l_lor_details.disclosure_print_ind) ,' '),1)
788: ||RPAD(NVL(student_dtl_rec.p_email_addr,' '),50) -- #149
789: transaction_rec
790: FROM dual;
791:
792: ELSIF p_dl_loan_catg = 'DL_PLUS' THEN
793:
794: OPEN Orig_Rec FOR

Line 848: FROM dual;

844: 'N',' ',
845: l_lor_details.disclosure_print_ind) ,' '),1)
846: ||RPAD(NVL(student_dtl_rec.p_email_addr,' '),50) -- #149
847: transaction_rec
848: FROM dual;
849: END IF;
850: END IF;
851:
852: EXCEPTION