APPS.IGS_PS_VAL_UV dependencies on IGS_PS_UNIT_OFR_PAT

Line 504: -- IGS_PS_UNIT_OFR_PAT,

500: -- IGS_PS_UNIT_REF_CD.
501: -- If IGS_PS_UNIT version is altered from a system status of planned to
502: -- active then check:
503: -- IGS_PS_UNIT_OFR,
504: -- IGS_PS_UNIT_OFR_PAT,
505: -- IGS_PS_UNIT_OFR_OPT.
506: -- * Validate that where tables contains fields that hold percentages, that
507: -- the records total 100% for the given IGS_PS_UNIT version. The relevant tables
508: -- are:

Line 558: FROM IGS_PS_UNIT_OFR_PAT

554: version_number = p_version_number;
555: CURSOR c_unit_offering_pattern IS
556: SELECT cal_type,
557: ci_sequence_number
558: FROM IGS_PS_UNIT_OFR_PAT
559: WHERE unit_cd = p_unit_cd AND
560: version_number = p_version_number
561: AND delete_flag = 'N';
562: CURSOR c_unit_offering_option IS