APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_OR_INST_ORG_BASE_V

Line 2515: sommukhe 16-FEB-2006 Bug#3094371, replaced IGS_OR_UNIT by igs_or_inst_org_base_v for cursor c_org

2511:
2512: Known limitations,enhancements,remarks:
2513: Change History (in reverse chronological order)
2514: Who When What
2515: sommukhe 16-FEB-2006 Bug#3094371, replaced IGS_OR_UNIT by igs_or_inst_org_base_v for cursor c_org
2516: ********************************************************************************************** */
2517:
2518: CURSOR c_clstd(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2519: SELECT 'X'

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 2664: sommukhe 16-FEB-2006 Bug#3094371, replaced IGS_OR_UNIT by igs_or_inst_org_base_v for cursor c_org

2660:
2661: Known limitations,enhancements,remarks:
2662: Change History (in reverse chronological order)
2663: Who When What
2664: sommukhe 16-FEB-2006 Bug#3094371, replaced IGS_OR_UNIT by igs_or_inst_org_base_v for cursor c_org
2665: ********************************************************************************************** */
2666:
2667: CURSOR c_clstd(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE) IS
2668: SELECT 'X'

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;