DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PR_S_OU_PRG_CAL

Line 302: FROM IGS_PR_S_OU_PRG_CAL sopc1,

298: spc1.prg_cal_type = cp_spo_prg_cal_type AND
299: spc2.prg_cal_type = ci.cal_type AND
300: spc1.stream_num = spc2.stream_num) OR
301: EXISTS (SELECT 'x'
302: FROM IGS_PR_S_OU_PRG_CAL sopc1,
303: IGS_PR_S_OU_PRG_CAL sopc2
304: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT( p_course_cd,
305: cp_sca_version_number,
306: sopc1.org_unit_cd,

Line 303: IGS_PR_S_OU_PRG_CAL sopc2

299: spc2.prg_cal_type = ci.cal_type AND
300: spc1.stream_num = spc2.stream_num) OR
301: EXISTS (SELECT 'x'
302: FROM IGS_PR_S_OU_PRG_CAL sopc1,
303: IGS_PR_S_OU_PRG_CAL sopc2
304: WHERE IGS_PR_GEN_001.PRGP_GET_CRV_CMT( p_course_cd,
305: cp_sca_version_number,
306: sopc1.org_unit_cd,
307: sopc1.ou_start_dt) = 'Y' AND