[Home] [Help]
3623: c_prod_usec_rec c_prod_usec%ROWTYPE;
3624:
3625: CURSOR c_prod_pat (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*
3630: FROM igs_ps_unit_ofr_pat_all pt
3631: WHERE cal_type=cp_cal_type
3624:
3625: CURSOR c_prod_pat (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*
3630: FROM igs_ps_unit_ofr_pat_all pt
3631: WHERE cal_type=cp_cal_type
3632: AND ci_sequence_number =cp_sequence_number
3626: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE,
3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS
3629: SELECT pt.ROWID prodrid,pt.*
3630: FROM igs_ps_unit_ofr_pat_all pt
3631: WHERE cal_type=cp_cal_type
3632: AND ci_sequence_number =cp_sequence_number
3633: AND unit_cd= cp_unit_cd
3634: AND version_number=cp_version_number;