DBA Data[Home] [Help]

APPS.IGW_PROP_PERSON_SUPPORT_PVT dependencies on GMS_PERSONNEL

Line 279: from gms_personnel gp,

275: pa.funding_source_id,
276: pa.start_date_active,
277: pa.end_date_active,
278: pa.proposal_id
279: from gms_personnel gp,
280: igw_awards_v pa
281: where gp.person_id = p_person_id AND
282: gp.award_id = pa.award_id AND
283: pa.status = 'ACTIVE' AND

Line 297: from gms_personnel gp,

293: pa.funding_source_id,
294: pa.start_date_active,
295: pa.end_date_active,
296: pa.proposal_id
297: from gms_personnel gp,
298: igw_awards_v pa
299: where gp.person_id = p_person_id AND
300: gp.award_id = pa.award_id AND
301: pa.close_date > x_date_minus_three_yrs AND