APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_OR_STATUS

Line 2571: FROM igs_or_inst_org_base_v a, igs_or_status b

2567: c_pgrp_rec c_pgrp%ROWTYPE;
2568:
2569: CURSOR c_org(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2570: SELECT 'X'
2571: FROM igs_or_inst_org_base_v a, igs_or_status b
2572: WHERE a.party_number = cp_preference_code
2573: AND a.org_status = b.org_status
2574: AND b.s_org_status <> 'INACTIVE';
2575: c_org_rec c_org%ROWTYPE;

Line 2707: FROM igs_or_inst_org_base_v a, igs_or_status b

2703: c_unit_set_rec c_unit_set%ROWTYPE;
2704:
2705: CURSOR c_org(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2706: SELECT 'X'
2707: FROM igs_or_inst_org_base_v a, igs_or_status b
2708: WHERE a.party_number = cp_preference_code
2709: AND a.org_status = b.org_status
2710: AND b.s_org_status <> 'INACTIVE';
2711: c_org_rec c_org%ROWTYPE;