DBA Data[Home] [Help]

APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_EDIT_REPORT_V

Line 1910: CURSOR c_reject (p_chg_code igf_sl_edit_report_v.orig_chg_code%TYPE)

1906:
1907: err_mesg_array t_message;
1908:
1909: --Select the Error Messages from Edit Report
1910: CURSOR c_reject (p_chg_code igf_sl_edit_report_v.orig_chg_code%TYPE)
1911: IS
1912: SELECT rpad(field_desc,50)||sl_error_desc reject_desc FROM igf_sl_edit_report_v
1913: WHERE loan_number = loaded_1rec.loan_number
1914: AND orig_chg_code = p_chg_code

Line 1912: SELECT rpad(field_desc,50)||sl_error_desc reject_desc FROM igf_sl_edit_report_v

1908:
1909: --Select the Error Messages from Edit Report
1910: CURSOR c_reject (p_chg_code igf_sl_edit_report_v.orig_chg_code%TYPE)
1911: IS
1912: SELECT rpad(field_desc,50)||sl_error_desc reject_desc FROM igf_sl_edit_report_v
1913: WHERE loan_number = loaded_1rec.loan_number
1914: AND orig_chg_code = p_chg_code
1915: ORDER BY edtr_id;
1916: