APPS.IGS_PR_GEN_006 dependencies on IGS_PR_S_PRG_CAL

Line 294: FROM IGS_PR_S_PRG_CAL spc1,

290: cs.cal_status = ci.cal_status AND
291: cs.s_cal_status = cst_active AND
292: ci.start_dt > cp_prg_start_dt AND
293: ( EXISTS (SELECT 'x'
294: FROM IGS_PR_S_PRG_CAL spc1,
295: IGS_PR_S_PRG_CAL spc2
296: WHERE spc1.s_control_num = 1 AND
297: spc2.s_control_num = 1 AND
298: spc1.prg_cal_type = cp_spo_prg_cal_type AND

Line 295: IGS_PR_S_PRG_CAL spc2

291: cs.s_cal_status = cst_active AND
292: ci.start_dt > cp_prg_start_dt AND
293: ( EXISTS (SELECT 'x'
294: FROM IGS_PR_S_PRG_CAL spc1,
295: IGS_PR_S_PRG_CAL spc2
296: WHERE spc1.s_control_num = 1 AND
297: spc2.s_control_num = 1 AND
298: spc1.prg_cal_type = cp_spo_prg_cal_type AND
299: spc2.prg_cal_type = ci.cal_type AND