DBA Data[Home] [Help]

APPS.IGS_PS_VAL_UOO dependencies on IGS_EN_GEN_003

Line 106: SELECT IGS_EN_GEN_003.Get_Staff_Ind(party_id) staff_member_ind

102: BEGIN
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;