DBA Data[Home] [Help]

APPS.IGS_AD_IMP_006 dependencies on IGS_AD_EXTRACURR_ACT_V

Line 947: l_last_update_date IGS_AD_EXTRACURR_ACT_V.LAST_UPDATE_DATE%TYPE;

943: P_BATCH_ID IN VARCHAR2
944: ) AS
945:
946: l_dup_person_interest_id IGS_AD_EXCURR_INT.DUP_PERSON_INTEREST_ID%TYPE;
947: l_last_update_date IGS_AD_EXTRACURR_ACT_V.LAST_UPDATE_DATE%TYPE;
948: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
949: CURSOR extracurr(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
950: SELECT hii.*, i.person_id
951: FROM igs_ad_excurr_int_all hii, igs_ad_interface_all i