APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on IRC_OFFERS

Line 240: from irc_offer_status_history ofrhis, irc_offers ofr, per_all_assignments_f paaf

236: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
237: cursor csr_offer_status is
238: select * from(
239: select ofrhis.offer_status, ofrhis.change_reason, ofrhis.decline_reason
240: from irc_offer_status_history ofrhis, irc_offers ofr, per_all_assignments_f paaf
241: where paaf.assignment_id = pAssignmentId and ofr.applicant_assignment_id = paaf.assignment_id
242: and ofrhis.offer_id = ofr.offer_id and ofr.latest_offer='Y'
243: and sysdate between paaf.effective_start_date and paaf.effective_end_date order by status_change_date desc)
244: where rownum<2;