APPS.IGS_PS_GEN_001 dependencies on IGS_OR_STATUS

Line 3901: igs_or_status os

3897: CURSOR c_ou( cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
3898: cp_start_dt igs_or_unit.start_dt%TYPE) IS
3899: SELECT 'x'
3900: FROM igs_or_inst_org_base_v ou,
3901: igs_or_status os
3902: WHERE ou.party_number = cp_org_unit_cd
3903: AND ou.start_dt = cp_start_dt
3904: AND os.org_status = ou.org_status
3905: AND os.s_org_status = cst_active;