APPS.IGS_PR_VAL_SOPC dependencies on IGS_OR_STATUS

Line 210: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;

206: BEGIN -- prgp_val_ou_active
207: -- Validate that the IGS_OR_UNIT is active.
208: DECLARE
209: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
210: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;
211: CURSOR c_os_ou IS
212: SELECT os.s_org_status
213: FROM IGS_OR_UNIT ou,
214: IGS_OR_STATUS os

Line 214: IGS_OR_STATUS os

210: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;
211: CURSOR c_os_ou IS
212: SELECT os.s_org_status
213: FROM IGS_OR_UNIT ou,
214: IGS_OR_STATUS os
215: WHERE ou.org_unit_cd = p_org_unit_cd AND
216: ou.start_dt = p_start_dt AND
217: os.org_status = ou.org_status;
218: BEGIN