DBA Data[Home] [Help]

APPS.IGS_EN_GEN_018 dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 134: alternate_cd IN ( SELECT teach_alternate_code FROM igs_ca_load_to_teach_v

130: AND program_cd = NVL(p_program_cd ,program_cd)
131: AND program_ver_num = NVL(p_program_ver,program_ver_num)
132: AND ((p_load_alt_code IS NULL) OR
133: ((p_load_alt_code IS NOT NULL)AND
134: alternate_cd IN ( SELECT teach_alternate_code FROM igs_ca_load_to_teach_v
135: WHERE load_alternate_code=p_load_alt_code)));
136:
137: IF p_load_alt_code IS NULL THEN -- group header has not yet been put..teach code will be not null only in case of teach calendar errors or relationship errors
138: --group header