APPS.IGS_EN_GEN_011 dependencies on DUAL

Line 5558: FROM DUAL;

5554:
5555:
5556: SELECT DECODE(GREATEST(v_pcge_rec.pcge_start_dt, p_expiry_dt),v_pcge_rec.pcge_start_dt, v_pcge_rec.pcge_start_dt, p_expiry_dt)
5557: INTO l_dcd_date
5558: FROM DUAL;
5559:
5560: IGS_PE_CRS_GRP_EXCL_PKG.UPDATE_ROW(
5561: X_ROWID => v_pcge_rec.ROWID ,
5562: X_PERSON_ID => v_pcge_rec.PERSON_ID ,

Line 5580: FROM DUAL;

5576: FOR v_pce_rec IN c_person_course_exclusion LOOP
5577:
5578: SELECT DECODE(GREATEST(v_pce_rec.pce_start_dt, p_expiry_dt),v_pce_rec.pce_start_dt, v_pce_rec.pce_start_dt,p_expiry_dt)
5579: INTO l_dcd_date
5580: FROM DUAL;
5581:
5582:
5583: IGS_PE_COURSE_EXCL_PKG.UPDATE_ROW(
5584: X_ROWID => v_pce_rec.ROWID ,

Line 5603: FROM DUAL;

5599: SELECT DECODE(GREATEST(v_pue_rec.pue_start_dt, p_expiry_dt),
5600: v_pue_rec.pue_start_dt, v_pue_rec.pue_start_dt,
5601: p_expiry_dt)
5602: INTO l_dcd_date
5603: FROM DUAL;
5604:
5605: IGS_PE_PERS_UNT_EXCL_PKG.UPDATE_ROW(
5606: X_ROWID => v_pue_rec.ROWID ,
5607: X_PERSON_ID => v_pue_rec.PERSON_ID ,

Line 5624: FROM DUAL;

5620: FOR v_pur_rec IN c_person_unit_requirement LOOP
5621:
5622: SELECT DECODE(GREATEST(v_pur_rec.pur_start_dt, p_expiry_dt),v_pur_rec.pur_start_dt, v_pur_rec.pur_start_dt,p_expiry_dt)
5623: INTO l_dcd_date
5624: FROM DUAL;
5625:
5626:
5627: IGS_PE_UNT_REQUIRMNT_PKG.UPDATE_ROW(
5628: X_ROWID => v_pur_rec.ROWID ,

Line 5646: FROM DUAL;

5642: FOR fund_exclusion_rec IN fund_exclusion_cur LOOP
5643:
5644: SELECT DECODE(GREATEST(fund_exclusion_rec.pfe_start_dt, p_expiry_dt),fund_exclusion_rec.pfe_start_dt, fund_exclusion_rec.pfe_start_dt,p_expiry_dt)
5645: INTO l_dcd_date
5646: FROM DUAL;
5647:
5648:
5649: IGS_PE_FUND_EXCL_PKG.UPDATE_ROW(
5650: X_ROWID => fund_exclusion_rec.ROWID ,