APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGF_AP_ISIR_INTS_ALL

Line 513: igf_ap_isir_ints_all a

509: CURSOR c_cps_int_data(p_batch_year VARCHAR2 )
510: IS
511: SELECT rowid row_id, a.*
512: FROM
513: igf_ap_isir_ints_all a
514: WHERE
515: a.record_status = 'LEGACY' AND
516: a.batch_year_num = p_batch_year
517: ORDER BY a.original_ssn_txt;

Line 5830: FUNCTION remove_spl_chr(pv_ssn IN igf_ap_isir_ints_all.CURRENT_SSN_TXT%TYPE)

5826:
5827: END validate_isir_rec;
5828:
5829:
5830: FUNCTION remove_spl_chr(pv_ssn IN igf_ap_isir_ints_all.CURRENT_SSN_TXT%TYPE)
5831: RETURN VARCHAR2
5832: IS
5833: /*
5834: || Created By : rasingh

Line 6407: UPDATE igf_ap_isir_ints_all

6403: SET IMPORT_STATUS_TYPE='I'
6404: WHERE ROWID = c_int_data_rec.ROW_ID ;
6405: END IF;
6406: ELSE -- CPS IMPORT
6407: UPDATE igf_ap_isir_ints_all
6408: SET RECORD_STATUS ='MATCHED'
6409: WHERE ROWID = c_int_data_rec.ROW_ID ;
6410: END IF;
6411: END IF;