APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGF_AP_CSS_INTERFACE

Line 724: FROM IGF_AP_CSS_INTERFACE_ALL A

720:
721: CURSOR c_css_int_data(p_award_year NUMBER )IS
722: SELECT
723: ROWID row_id, A.*
724: FROM IGF_AP_CSS_INTERFACE_ALL A
725: WHERE A.RECORD_STATUS = 'LEGACY' AND
726: TO_NUMBER(A.ACADEMIC_YEAR) = p_award_year;
727:
728: l_css_int_data_rec c_css_int_data%ROWTYPE;

Line 6155: UPDATE igf_ap_css_interface

6151: UPDATE igf_ap_li_css_ints
6152: SET import_status_type='I'
6153: WHERE ROWID = c_int_data_rec.row_id ;
6154: ELSE
6155: UPDATE igf_ap_css_interface
6156: SET RECORD_STATUS = 'MATCHED'
6157: WHERE ROWID = c_int_data_rec.row_id ;
6158: END IF;
6159: l_debug_str := l_debug_str || lv_person_number || ' PROFILE Record updated ';