DBA Data[Home] [Help]

APPS.IGS_RE_VAL_RSUP dependencies on IGS_OR_INSTITUTION

Line 779: v_c_ooi_lii IGS_OR_INSTITUTION.local_institution_ind%TYPE;

775: AND org.party_number = p_org_unit_cd
776: AND org.start_dt = p_ou_start_dt;
777:
778: v_c_ooi_sos IGS_OR_STATUS.s_org_status%TYPE;
779: v_c_ooi_lii IGS_OR_INSTITUTION.local_institution_ind%TYPE;
780: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
781: BEGIN
782: -- Set the default message number
783: p_message_name := NULL;

Line 806: -- Must be a local IGS_OR_INSTITUTION organisational IGS_PS_UNIT if

802: END IF;
803: END IF;
804:
805: IF v_staff_member_ind = 'Y' THEN
806: -- Must be a local IGS_OR_INSTITUTION organisational IGS_PS_UNIT if
807: -- supervisor is a staff member.
808: IF v_c_ooi_lii ='N' THEN
809: p_message_name := 'IGS_RE_CHK_ORG_UNIT';
810: IF p_legacy <> 'Y' THEN