APPS.IGW_PROP_PERSON_SUPPORT_PVT dependencies on IGW_AWARDS_V

Line 240: prop_id number; -- This is proposal_id in igw_awards_v

236: v_pi_name per_all_people_f.FULL_NAME%TYPE;
237: deadline_date date;
238: x_date date;
239: x_date_minus_three_yrs date;
240: prop_id number; -- This is proposal_id in igw_awards_v
241: percent_effort number;
242: x_rowid varchar2(30);
243: x_prop_person_support_id number;
244:

Line 280: igw_awards_v pa

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
284: ((pa.proposal_id <> p_proposal_id) OR (pa.proposal_id is NULL));

Line 298: igw_awards_v pa

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
302: pa.close_date < x_date AND