eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on IRC_OFFER_STATUS_HISTORY

Line 234: l_offer_status irc_offer_status_history.offer_status%TYPE;

230: --
231: l_proc varchar2(80) default g_package||'.is_offer_accepted_or_extended';
232: l_person_name_with_id varchar2(300);
233: l_description varchar2(500);
234: l_offer_status irc_offer_status_history.offer_status%TYPE;
235: l_change_reason irc_offer_status_history.change_reason%TYPE;
236: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
237: cursor csr_offer_status is
238: select * from(

Line 235: l_change_reason irc_offer_status_history.change_reason%TYPE;

231: l_proc varchar2(80) default g_package||'.is_offer_accepted_or_extended';
232: l_person_name_with_id varchar2(300);
233: l_description varchar2(500);
234: l_offer_status irc_offer_status_history.offer_status%TYPE;
235: l_change_reason irc_offer_status_history.change_reason%TYPE;
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

Line 236: l_decline_reason irc_offer_status_history.decline_reason%TYPE;

232: l_person_name_with_id varchar2(300);
233: l_description varchar2(500);
234: l_offer_status irc_offer_status_history.offer_status%TYPE;
235: l_change_reason irc_offer_status_history.change_reason%TYPE;
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

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;