APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_PS_UNIT_STAT

Line 3732: igs_ps_unit_stat stat

3728:
3729: CURSOR cur_chk_version(cp_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE,cp_v_unit_version_number igs_fi_unit_fee_trg.version_number%TYPE) IS
3730: SELECT 'x'
3731: FROM igs_ps_unit_ver psv,
3732: igs_ps_unit_stat stat
3733: WHERE psv.unit_cd = cp_v_unit_cd
3734: AND (psv.version_number = cp_v_unit_version_number OR cp_v_unit_version_number IS NULL)
3735: AND psv.unit_status = stat.unit_status
3736: AND stat.s_unit_status IN ('ACTIVE','PLANNED');