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.IRC_RECRUITMENT_SUMMARY_PKG dependencies on IRC_OFFERS

Line 429: irc_offers iof

425: from
426: irc_vac_summary ivs,
427: per_all_vacancies pav,
428: per_all_assignments_f paf,
429: irc_offers iof
430: where
431: pav.vacancy_id = ivs.vacancy_id
432: and paf.vacancy_id(+) = pav.vacancy_id
433: and iof.vacancy_id(+) = pav.vacancy_id

Line 570: FROM irc_offers offer

566: --
567: union
568: --
569: SELECT DISTINCT offer.vacancy_id,offer.applicant_assignment_id,'PENDING_FOR_APPROVAL_OFFERS'
570: FROM irc_offers offer
571: WHERE offer.vacancy_id = l_vacancy_id
572: AND offer.latest_offer = 'Y'
573: AND offer.offer_status = 'PENDING'
574: --

Line 578: FROM irc_offers offer

574: --
575: union
576: --
577: SELECT DISTINCT offer.vacancy_id,offer.applicant_assignment_id,'APPROVED_OFFERS'
578: FROM irc_offers offer
579: WHERE offer.vacancy_id = l_vacancy_id
580: AND offer.latest_offer = 'Y'
581: AND offer.offer_status = 'APPROVED'
582: --

Line 586: FROM irc_offers offer

582: --
583: union
584: --
585: SELECT DISTINCT offer.vacancy_id,offer.applicant_assignment_id,'EXTENDED_OFFERS'
586: FROM irc_offers offer
587: WHERE offer.vacancy_id = l_vacancy_id
588: AND offer.latest_offer = 'Y'
589: AND offer.offer_status = 'EXTENDED'
590: --

Line 594: FROM irc_offers offer ,

590: --
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'

Line 611: FROM irc_offers offer ,

607: --
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'

Line 628: FROM irc_offers offer

624: --
625: union
626: --
627: SELECT DISTINCT offer.vacancy_id,offer.applicant_assignment_id,'ON_HOLD_OFFERS'
628: FROM irc_offers offer
629: WHERE offer.vacancy_id = l_vacancy_id
630: AND offer.latest_offer = 'Y'
631: AND offer.offer_status = 'HOLD'
632: --

Line 636: FROM irc_offers offer ,

632: --
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'

Line 826: FROM irc_offers offer,

822: --
823: union
824: --
825: SELECT DISTINCT ivs.vacancy_id,offer.applicant_assignment_id,'PENDING_FOR_APPROVAL_OFFERS'
826: FROM irc_offers offer,
827: irc_vac_summary ivs
828: WHERE offer.vacancy_id = ivs.vacancy_id
829: AND offer.latest_offer = 'Y'
830: AND offer.offer_status = 'PENDING'

Line 836: FROM irc_offers offer,

832: --
833: union
834: --
835: SELECT DISTINCT ivs.vacancy_id,offer.applicant_assignment_id,'APPROVED_OFFERS'
836: FROM irc_offers offer,
837: irc_vac_summary ivs
838: WHERE offer.vacancy_id = ivs.vacancy_id
839: AND offer.latest_offer = 'Y'
840: AND offer.offer_status = 'APPROVED'

Line 846: FROM irc_offers offer,

842: --
843: union
844: --
845: SELECT DISTINCT ivs.vacancy_id,offer.applicant_assignment_id,'EXTENDED_OFFERS'
846: FROM irc_offers offer,
847: irc_vac_summary ivs
848: WHERE offer.vacancy_id = ivs.vacancy_id
849: AND offer.latest_offer = 'Y'
850: AND offer.offer_status = 'EXTENDED'

Line 856: FROM irc_offers offer ,

852: --
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'

Line 875: FROM irc_offers offer ,

871: --
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'

Line 894: FROM irc_offers offer,

890: --
891: union
892: --
893: SELECT DISTINCT ivs.vacancy_id,offer.applicant_assignment_id,'ON_HOLD_OFFERS'
894: FROM irc_offers offer,
895: irc_vac_summary ivs
896: WHERE offer.vacancy_id = ivs.vacancy_id
897: AND offer.latest_offer = 'Y'
898: AND offer.offer_status = 'HOLD'

Line 904: FROM irc_offers offer ,

900: --
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'