APPS.IGF_SL_GEN dependencies on IGF_SL_CLCHSN_DTLS

Line 1828: FROM igf_sl_clchsn_dtls

1824: rec_c_sl_loans c_sl_loans%ROWTYPE;
1825:
1826: CURSOR c_clchsn (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1827: SELECT 'x'
1828: FROM igf_sl_clchsn_dtls
1829: WHERE loan_number_txt = cp_loan_number_txt
1830: AND status_code = 'S';
1831:
1832: rec_c_clchsn c_clchsn%ROWTYPE;

Line 1836: FROM igf_sl_clchsn_dtls

1832: rec_c_clchsn c_clchsn%ROWTYPE;
1833:
1834: CURSOR c_clchsn2 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1835: SELECT 'x'
1836: FROM igf_sl_clchsn_dtls
1837: WHERE loan_number_txt = cp_loan_number_txt
1838: AND status_code = 'A'
1839: AND response_status_code = 'R';
1840:

Line 1846: FROM igf_sl_clchsn_dtls

1842:
1843:
1844: CURSOR c_clchsn3 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1845: SELECT 'x'
1846: FROM igf_sl_clchsn_dtls
1847: WHERE loan_number_txt = cp_loan_number_txt
1848: AND status_code = 'A'
1849: AND (response_status_code = 'F' OR response_status_code = 'P') ;
1850:

Line 1855: FROM igf_sl_clchsn_dtls

1851: rec_c_clchsn3 c_clchsn2%ROWTYPE;
1852:
1853: CURSOR c_get_clchsn_accept (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1854: SELECT 'x'
1855: FROM igf_sl_clchsn_dtls
1856: WHERE loan_number_txt = cp_loan_number_txt
1857: AND status_code = 'A'
1858: AND response_status_code = 'A';
1859:

Line 1864: FROM igf_sl_clchsn_dtls

1860: rec_c_get_clchsn_accept c_get_clchsn_accept%ROWTYPE;
1861:
1862: CURSOR c_clchsn4 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1863: SELECT 'x'
1864: FROM igf_sl_clchsn_dtls
1865: WHERE loan_number_txt = cp_loan_number_txt
1866: AND status_code = 'R';
1867:
1868: rec_c_clchsn4 c_clchsn4%ROWTYPE;