APPS.IRC_RECRUITMENT_SUMMARY_PKG dependencies on IRC_OFFER_STATUS_HISTORY

Line 595: irc_offer_status_history hist

591: union
592: --
593: SELECT DISTINCT offer.vacancy_id,offer.applicant_assignment_id,'ACCEPTED_OFFERS'
594: FROM irc_offers offer ,
595: irc_offer_status_history hist
596: WHERE offer.vacancy_id = l_vacancy_id
597: AND offer.latest_offer = 'Y'
598: AND offer.offer_status = 'CLOSED'
599: AND hist.offer_id = offer.offer_id

Line 604: from irc_offer_status_history

600: AND hist.change_reason = 'APL_ACCEPTED'
601: AND hist.status_change_date =
602: (
603: select max(status_change_date)
604: from irc_offer_status_history
605: where offer_id = offer.offer_id
606: )
607: --
608: union

Line 612: irc_offer_status_history hist

608: union
609: --
610: SELECT DISTINCT offer.vacancy_id,offer.applicant_assignment_id,'REJECTED_OFFERS'
611: FROM irc_offers offer ,
612: irc_offer_status_history hist
613: WHERE offer.vacancy_id = l_vacancy_id
614: AND offer.latest_offer = 'Y'
615: AND offer.offer_status = 'CLOSED'
616: AND hist.offer_id = offer.offer_id

Line 621: from irc_offer_status_history

617: AND hist.change_reason = 'APL_DECLINED'
618: AND hist.status_change_date =
619: (
620: select max(status_change_date)
621: from irc_offer_status_history
622: where offer_id = offer.offer_id
623: )
624: --
625: union

Line 637: irc_offer_status_history hist

633: union
634: --
635: SELECT DISTINCT offer.vacancy_id,offer.applicant_assignment_id,'WITHDRAWN_OFFERS'
636: FROM irc_offers offer ,
637: irc_offer_status_history hist
638: WHERE offer.vacancy_id = l_vacancy_id
639: AND offer.latest_offer = 'Y'
640: AND offer.offer_status = 'CLOSED'
641: AND hist.offer_id = offer.offer_id

Line 646: from irc_offer_status_history

642: AND hist.change_reason = 'MGR_WITHDRAW'
643: AND hist.status_change_date =
644: (
645: select max(status_change_date)
646: from irc_offer_status_history
647: where offer_id = offer.offer_id
648: );
649: --
650: --Populate summary count columns in irc_vac_summary table from data populated

Line 857: irc_offer_status_history hist,

853: union
854: --
855: SELECT DISTINCT ivs.vacancy_id,offer.applicant_assignment_id,'ACCEPTED_OFFERS'
856: FROM irc_offers offer ,
857: irc_offer_status_history hist,
858: irc_vac_summary ivs
859: WHERE offer.vacancy_id = ivs.vacancy_id
860: AND offer.latest_offer = 'Y'
861: AND offer.offer_status = 'CLOSED'

Line 867: from irc_offer_status_history

863: AND hist.change_reason = 'APL_ACCEPTED'
864: AND hist.status_change_date =
865: (
866: select max(status_change_date)
867: from irc_offer_status_history
868: where offer_id = offer.offer_id
869: )
870: AND ivs.rowid between p_start_rowid and p_end_rowid
871: --

Line 876: irc_offer_status_history hist,

872: union
873: --
874: SELECT DISTINCT ivs.vacancy_id,offer.applicant_assignment_id,'REJECTED_OFFERS'
875: FROM irc_offers offer ,
876: irc_offer_status_history hist,
877: irc_vac_summary ivs
878: WHERE offer.vacancy_id = ivs.vacancy_id
879: AND offer.latest_offer = 'Y'
880: AND offer.offer_status = 'CLOSED'

Line 886: from irc_offer_status_history

882: AND hist.change_reason = 'APL_DECLINED'
883: AND hist.status_change_date =
884: (
885: select max(status_change_date)
886: from irc_offer_status_history
887: where offer_id = offer.offer_id
888: )
889: AND ivs.rowid between p_start_rowid and p_end_rowid
890: --

Line 905: irc_offer_status_history hist,

901: union
902: --
903: SELECT DISTINCT ivs.vacancy_id,offer.applicant_assignment_id,'WITHDRAWN_OFFERS'
904: FROM irc_offers offer ,
905: irc_offer_status_history hist,
906: irc_vac_summary ivs
907: WHERE offer.vacancy_id = ivs.vacancy_id
908: AND offer.latest_offer = 'Y'
909: AND offer.offer_status = 'CLOSED'

Line 915: from irc_offer_status_history

911: AND hist.change_reason = 'MGR_WITHDRAW'
912: AND hist.status_change_date =
913: (
914: select max(status_change_date)
915: from irc_offer_status_history
916: where offer_id = offer.offer_id
917: )
918: AND ivs.rowid between p_start_rowid and p_end_rowid;
919: --