APPS.IGF_SL_UPLOAD_XML dependencies on IGF_GR_COD_DTLS

Line 1391: FROM IGF_GR_COD_DTLS

1387: cp_dob DATE,
1388: cp_fin_awd_yr VARCHAR2
1389: ) IS
1390: SELECT *
1391: FROM IGF_GR_COD_DTLS
1392: WHERE S_SSN = cp_ssn
1393: AND S_DATE_OF_BIRTH = cp_dob
1394: AND S_LAST_NAME = cp_lname
1395: AND FIN_AWARD_YEAR = cp_fin_awd_yr;

Line 1800: FROM IGF_GR_COD_DTLS codpell

1796: FROM IGF_SL_COD_TEMP;
1797:
1798: CURSOR get_cods_for_student ( cp_ssn VARCHAR2, cp_lname VARCHAR2, cp_dob DATE) IS
1799: SELECT codpell.ROWID row_id, codpell.*
1800: FROM IGF_GR_COD_DTLS codpell
1801: WHERE codpell.s_ssn = cp_ssn
1802: AND codpell.s_last_name = cp_lname
1803: AND codpell.s_date_of_birth = cp_dob;
1804:

Line 2141: igf_gr_cod_dtls_pkg.update_row(

2137: -- Update student pell records with new student identifier info.
2138: -- Student will have only one Pell award, but still used For loop for consistency purpose.
2139: FOR rec IN get_cods_for_student(l_st_resp.s_ssn,l_st_resp.s_last_name,l_st_resp.s_date_of_birth)
2140: LOOP
2141: igf_gr_cod_dtls_pkg.update_row(
2142: x_rowid => rec.row_id,
2143: x_origination_id => rec.origination_id,
2144: x_award_id => rec.award_id,
2145: x_document_id_txt => rec.document_id_txt,