APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_AS_RESP_DTLS

Line 101: DELETE IGF_SL_AS_RESP_DTLS WHERE ATD_SCHL_RESP_ID = l_temp.REC_ID;

97: DELETE IGF_SL_CR_RESP_DTLS WHERE DOCUMENT_ID_TXT = l_temp.REC_ID;
98: ELSIF l_temp.LEVEL_CODE = 'RS' THEN
99: DELETE IGF_SL_RS_RESP_DTLS WHERE REP_SCHL_RESP_ID = l_temp.REC_ID;
100: ELSIF l_temp.LEVEL_CODE = 'AS' THEN
101: DELETE IGF_SL_AS_RESP_DTLS WHERE ATD_SCHL_RESP_ID = l_temp.REC_ID;
102: ELSIF l_temp.LEVEL_CODE = 'ST' THEN
103: DELETE IGF_SL_ST_RESP_DTLS WHERE STDNT_RESP_ID = l_temp.REC_ID;
104: ELSIF l_temp.LEVEL_CODE = 'AWD' THEN
105: DELETE IGF_SL_DL_RESP_DTLS WHERE DL_LOAN_RESP_ID = l_temp.REC_ID;

Line 1786: FROM IGF_SL_AS_RESP_DTLS

1782: FIN_AWARD_TYPE;
1783:
1784: CURSOR get_as_resp ( cp_rep_id NUMBER) IS
1785: SELECT *
1786: FROM IGF_SL_AS_RESP_DTLS
1787: WHERE REP_SCHL_RESP_ID = cp_rep_id;
1788:
1789: CURSOR get_st_resp ( cp_atd_id NUMBER) IS
1790: SELECT *

Line 1869: UPDATE IGF_SL_AS_RESP_DTLS

1865: UPDATE IGF_SL_RS_RESP_DTLS
1866: SET RESP_CODE = l_temp.RESP_CODE
1867: WHERE REP_SCHL_RESP_ID = l_temp.REC_ID;
1868: ELSIF l_temp.LEVEL_CODE = 'AS' THEN
1869: UPDATE IGF_SL_AS_RESP_DTLS
1870: SET RESP_CODE = l_temp.RESP_CODE
1871: WHERE ATD_SCHL_RESP_ID = l_temp.REC_ID;
1872: ELSIF l_temp.LEVEL_CODE = 'ST' THEN
1873: UPDATE IGF_SL_ST_RESP_DTLS