DBA Data[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on IGS_CA_INST_ALL

Line 637: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,

633: **************************************************************************/
634:
635: CURSOR cur_unit_attmpt(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
636: cp_v_course_cd igs_en_su_attempt.course_cd%TYPE,
637: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
639: cp_v_nz_billable_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE
640: ) IS
641: SELECT sua.*, usec.non_std_usec_ind

Line 638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,

634:
635: CURSOR cur_unit_attmpt(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
636: cp_v_course_cd igs_en_su_attempt.course_cd%TYPE,
637: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
638: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
639: cp_v_nz_billable_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE
640: ) IS
641: SELECT sua.*, usec.non_std_usec_ind
642: FROM igs_en_su_attempt sua,