DBA Data[Home] [Help]

APPS.IGS_AD_IMP_011 dependencies on IGS_CA_INST_ALL

Line 638: CURSOR load_cal_cur (cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE)

634: SELECT birth_date birth_dt
635: FROM igs_pe_person_base_v
636: WHERE person_id = cp_person_id;
637:
638: CURSOR load_cal_cur (cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE)
639: IS
640: SELECT 1
641: FROM igs_ca_inst_all ca,
642: igs_ca_type typ,

Line 641: FROM igs_ca_inst_all ca,

637:
638: CURSOR load_cal_cur (cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_sequence_number igs_ca_inst_all.sequence_number%TYPE)
639: IS
640: SELECT 1
641: FROM igs_ca_inst_all ca,
642: igs_ca_type typ,
643: igs_ca_stat stat
644: WHERE typ.cal_type=ca.cal_type AND
645: typ.s_cal_cat = 'LOAD' AND