APPS.IGS_OR_VAL_OUR dependencies on IGS_OR_STATUS

Line 26: IGS_OR_STATUS

22: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
23: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS
24: SELECT s_org_status
25: FROM IGS_OR_UNIT,
26: IGS_OR_STATUS
27: WHERE org_unit_cd = cp_org_unit_cd
28: AND start_dt = cp_start_dt
29: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
30: AND s_org_status = 'INACTIVE';

Line 29: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status

25: FROM IGS_OR_UNIT,
26: IGS_OR_STATUS
27: WHERE org_unit_cd = cp_org_unit_cd
28: AND start_dt = cp_start_dt
29: AND IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
30: AND s_org_status = 'INACTIVE';
31: --
32: v_org_unit_exists BOOLEAN DEFAULT FALSE;
33: v_other_detail VARCHAR2(255);