APPS.IGW_VIEW_PARAMETERS dependencies on PER_PEOPLE_X

Line 106: from gms_personnel gp, per_people_x ppx

102: o_pi_name := 'pi';
103:
104: select gp.person_id, ppx.full_name
105: into o_pi_id, o_pi_name
106: from gms_personnel gp, per_people_x ppx
107: where gp.award_id = i_award_id and
108: gp.award_role = 'AM' and
109: prop_start_date >= gp.start_date_active and
110: prop_start_date <= nvl(gp.end_date_active, sysdate) and

Line 118: from gms_personnel gp, per_people_x ppx

114: when no_data_found then
115: begin
116: select gp.person_id, ppx.full_name
117: into o_pi_id, o_pi_name
118: from gms_personnel gp, per_people_x ppx
119: where gp.award_id = i_award_id and
120: gp.award_role = 'AM' and
121: gp.person_id = ppx.person_id and
122: rownum = 1;