APPS.IGS_PS_VAL_UV dependencies on IGS_PS_UNIT_REF_CD

Line 500: -- IGS_PS_UNIT_REF_CD.

496: -- for existing IGS_PS_UNIT_VER detail records such as:
497: -- IGS_PS_UNIT_DSCP,
498: -- IGS_PS_UNIT_CATEGORY,
499: -- IGS_PS_UNIT_LVL,
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,

Line 543: FROM IGS_PS_UNIT_REF_CD

539:
540: -- ijeddy 03-nov-2003 Bug# 3181938; Modified this object as per Summary Measurement Of Attainment FD.
541: CURSOR c_unit_reference_cd IS
542: SELECT reference_cd_type
543: FROM IGS_PS_UNIT_REF_CD
544: WHERE unit_cd = p_unit_cd AND
545: version_number = p_version_number;
546: CURSOR c_get_s_unit_status IS
547: SELECT s_unit_status

Line 678: -- Validate the IGS_PS_UNIT_REF_CD table and that IGS_GE_REF_CD_TYPE is not

674: END LOOP;
675: IF (v_terminate = TRUE) THEN
676: RETURN FALSE;
677: END IF;
678: -- Validate the IGS_PS_UNIT_REF_CD table and that IGS_GE_REF_CD_TYPE is not
679: -- closed
680: FOR urc_rec IN c_unit_reference_cd LOOP
681: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_URC.crsp_val_ref_cd_type
682: IF (IGS_PS_VAL_CRFC.crsp_val_ref_cd_type(