APPS.IGW_AWARD_PARTICULARS_PKG dependencies on PER_PEOPLE_X

Line 60: from gms_personnel gp, per_people_x ppx

56: o_pi_name := 'pi';
57:
58: select gp.person_id, ppx.full_name
59: into o_pi_id, o_pi_name
60: from gms_personnel gp, per_people_x ppx
61: where gp.award_id = i_award_id and
62: gp.award_role = 'AM' and
63: prop_start_date >= gp.start_date_active and
64: prop_start_date <= nvl(gp.end_date_active, sysdate) and

Line 71: from gms_personnel gp, per_people_x ppx

67: when no_data_found then
68: begin
69: select gp.person_id, ppx.full_name
70: into o_pi_id, o_pi_name
71: from gms_personnel gp, per_people_x ppx
72: where gp.award_id = i_award_id and
73: gp.award_role = 'AM' and
74: gp.person_id = ppx.person_id and
75: rownum = 1;