APPS.IGF_SL_LAR_CREATION dependencies on IGS_PE_EIT_RESTATUS_V

Line 269: FROM igs_pe_eit_restatus_v pct

265: --Bug# 5006583 - bvisvana
266: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
267: SELECT
268: pct.restatus_code
269: FROM igs_pe_eit_restatus_v pct
270: WHERE pct.person_id = cp_person_id
271: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
272:
273: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;

Line 1616: FROM igs_pe_eit_restatus_v pct

1612: --Bug# 5006583
1613: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
1614: SELECT
1615: pct.restatus_code
1616: FROM igs_pe_eit_restatus_v pct
1617: WHERE pct.person_id = cp_person_id
1618: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1619:
1620: l_cur_borrower_rec cur_borrower_id%ROWTYPE;

Line 2053: FROM igs_pe_eit_restatus_v pct

2049: --Bug# 5006583
2050: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
2051: SELECT
2052: pct.restatus_code
2053: FROM igs_pe_eit_restatus_v pct
2054: WHERE pct.person_id = cp_person_id
2055: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
2056:
2057: l_cur_borrower_rec cur_borrower_id%ROWTYPE;