APPS.IGS_EN_VAL_BULKRULE dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 308: FROM IGS_CA_LOAD_TO_TEACH_V

304: ) OR
305: ( cp_cal_cat = 'LOAD' AND
306: (sua.cal_type,sua.ci_sequence_number) IN
307: ( SELECT teach_cal_type,teach_ci_sequence_number
308: FROM IGS_CA_LOAD_TO_TEACH_V
309: WHERE load_cal_type LIKE NVL(p_cal_type,'%')
310: AND load_ci_sequence_number = nvl(p_ci_sequence_number,load_ci_sequence_number)
311: )
312: )

Line 862: FROM IGS_CA_LOAD_TO_TEACH_V

858: WHERE cal_type = p_cal_type ;
859:
860: CURSOR c_load_to_teach IS
861: SELECT teach_cal_type,teach_ci_sequence_number
862: FROM IGS_CA_LOAD_TO_TEACH_V
863: WHERE load_cal_type = p_cal_type
864: AND load_ci_sequence_number = nvl( p_ci_sequence_number ,load_ci_sequence_number);
865:
866: rec_teach c_load_to_teach%ROWTYPE;