DBA Data[Home] [Help]

APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_UNIT_OFR_PAT_ALL

Line 3627: cp_unit_cd igs_ps_unit_ofr_pat_all.unit_cd%TYPE,

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

Line 3628: cp_version_number igs_ps_unit_ofr_pat_all.version_number%TYPE) IS

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

Line 3630: FROM igs_ps_unit_ofr_pat_all pt

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;