APPS.IGS_PS_VAL_UOO dependencies on HZ_PARTIES

Line 6: --sommukhe 12-JAN-2006 Bug #4926548, In crsp_val_uoo_contact for cursor replaced IGS_PE_PERSON with HZ_PARTIES

2: /* $Header: IGSPS65B.pls 120.1 2006/01/31 01:52:34 sommukhe noship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --sommukhe 12-JAN-2006 Bug #4926548, In crsp_val_uoo_contact for cursor replaced IGS_PE_PERSON with HZ_PARTIES
7: --smadathi 24-AUG-2001 Bug No. 1956374 .The function genp_val_staff_prsn removed
8: --avenkatr 30-AUG-2001 Bug No 1956374. Removed procedure "crsp_val_crs_ci"
9: -------------------------------------------------------------------------------------------
10: --

Line 107: FROM hz_parties

103: DECLARE
104: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
105: CURSOR c_staff_member_ind IS
106: SELECT IGS_EN_GEN_003.Get_Staff_Ind(party_id) staff_member_ind
107: FROM hz_parties
108: WHERE party_id = p_person_id;
109: BEGIN
110: OPEN c_staff_member_ind;
111: FETCH c_staff_member_ind INTO v_staff_member_ind;