APPS.IGS_EN_VAL_SUA dependencies on HZ_PARTIES

Line 3479: SELECT party_number from hz_parties

3475: default_enroll_flag = 'Y' AND
3476: relation_type = 'SUBORDINATE';
3477:
3478: CURSOR cur_person_number IS
3479: SELECT party_number from hz_parties
3480: WHERE party_id = p_person_id;
3481:
3482: l_sub_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;