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 190: l_offer_status irc_offer_status_history.offer_status%TYPE;

186: --
187: l_proc varchar2(80) default g_package||'.is_offer_accepted_or_extended';
188: l_person_name_with_id varchar2(300);
189: l_description varchar2(500);
190: l_offer_status irc_offer_status_history.offer_status%TYPE;
191: l_change_reason irc_offer_status_history.change_reason%TYPE;
192: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
193: cursor csr_offer_status is
194: select * from(

Line 191: l_change_reason irc_offer_status_history.change_reason%TYPE;

187: l_proc varchar2(80) default g_package||'.is_offer_accepted_or_extended';
188: l_person_name_with_id varchar2(300);
189: l_description varchar2(500);
190: l_offer_status irc_offer_status_history.offer_status%TYPE;
191: l_change_reason irc_offer_status_history.change_reason%TYPE;
192: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
193: cursor csr_offer_status is
194: select * from(
195: select ofrhis.offer_status, ofrhis.change_reason, ofrhis.decline_reason

Line 192: l_decline_reason irc_offer_status_history.decline_reason%TYPE;

188: l_person_name_with_id varchar2(300);
189: l_description varchar2(500);
190: l_offer_status irc_offer_status_history.offer_status%TYPE;
191: l_change_reason irc_offer_status_history.change_reason%TYPE;
192: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
193: cursor csr_offer_status is
194: select * from(
195: select ofrhis.offer_status, ofrhis.change_reason, ofrhis.decline_reason
196: from irc_offer_status_history ofrhis, irc_offers ofr, per_all_assignments_f paaf

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

192: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
193: cursor csr_offer_status is
194: select * from(
195: select ofrhis.offer_status, ofrhis.change_reason, ofrhis.decline_reason
196: from irc_offer_status_history ofrhis, irc_offers ofr, per_all_assignments_f paaf
197: where paaf.assignment_id = pAssignmentId and ofr.applicant_assignment_id = paaf.assignment_id
198: and ofrhis.offer_id = ofr.offer_id and ofr.latest_offer='Y'
199: and sysdate between paaf.effective_start_date and paaf.effective_end_date order by status_change_date desc)
200: where rownum<2;