DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 4820: FROM igs_ca_load_to_teach_v

4816: AND ((p_calling_obj <> 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM') )
4817: OR (p_calling_obj = 'PLAN' AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM','PLANNED') )
4818: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
4819: AND (cal_type,ci_sequence_number) IN (SELECT teach_cal_type,teach_ci_sequence_number
4820: FROM igs_ca_load_to_teach_v
4821: WHERE load_cal_type = p_load_cal_type AND
4822: load_ci_sequence_number = p_load_sequence_number);
4823:
4824: -- Local variables