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 PER_ALL_ASSIGNMENTS_F

Line 336: per_all_assignments_f paf

332: (select vacancy_id from irc_vac_summary where manager_id=l_person_id and
333: rowid between p_start_rowid and p_end_rowid) vac,
334: (select distinct paf.person_id as manager_id
335: from
336: per_all_assignments_f paf
337: start with paf.person_id = l_person_id
338: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
339: and paf.primary_flag = 'Y'
340: and paf.assignment_type in ( 'E' , 'C' )

Line 378: per_all_assignments_f paf

374: (select vacancy_id from irc_vac_summary where recruiter_id=l_person_id and
375: rowid between p_start_rowid and p_end_rowid) vac,
376: (select distinct paf.person_id as recruiter_id
377: from
378: per_all_assignments_f paf
379: start with paf.person_id = l_person_id
380: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
381: and paf.primary_flag = 'Y'
382: and paf.assignment_type in ( 'E' , 'C' )

Line 428: per_all_assignments_f paf,

424: distinct ivs.rowid,ivs.vacancy_id,ivs.processed_status
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

Line 492: FROM per_all_assignments_f pasg

488: --
489: insert into irc_vac_summary_details (vacancy_id,assignment_id,summary_type)
490: --
491: SELECT DISTINCT pasg.vacancy_id,pasg.assignment_id,'TOTAL_APPLICATIONS'
492: FROM per_all_assignments_f pasg
493: WHERE pasg.assignment_type = 'A'
494: AND pasg.vacancy_id = l_vacancy_id
495: --
496: union

Line 499: FROM per_all_assignments_f pasg

495: --
496: union
497: --
498: SELECT DISTINCT pasg.vacancy_id,pasg.assignment_id,'ACTIVE_APPLICATIONS'
499: FROM per_all_assignments_f pasg
500: WHERE pasg.assignment_type = 'A'
501: AND pasg.vacancy_id = l_vacancy_id
502: AND trunc(sysdate) between pasg.effective_start_date and pasg.effective_end_date
503: --

Line 507: FROM per_all_assignments_f pasg

503: --
504: union
505: --
506: SELECT DISTINCT pasg.vacancy_id,pasg.assignment_id,'FILLED_APPLICATIONS'
507: FROM per_all_assignments_f pasg
508: WHERE pasg.assignment_type IN ('E','C')
509: AND pasg.vacancy_id = l_vacancy_id
510: --
511: union

Line 514: FROM per_all_assignments_f pasg,

510: --
511: union
512: --
513: SELECT DISTINCT ivla.vacancy_id,ivla.src_apl_asg_id,'FILLED_APPLICATIONS'
514: FROM per_all_assignments_f pasg,
515: per_vac_linked_assignments ivla
516: WHERE ivla.vacancy_id = l_vacancy_id
517: AND sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate)
518: AND ivla.tgt_apl_asg_id = pasg.assignment_id

Line 524: FROM per_all_assignments_f pasg ,

520: --
521: union
522: --
523: SELECT DISTINCT pasg.vacancy_id,pasg.assignment_id,'TO_BE_PROCESSED_APPLICATIONS'
524: FROM per_all_assignments_f pasg ,
525: irc_assignment_statuses ias,
526: per_assignment_status_types past
527: WHERE pasg.vacancy_id = l_vacancy_id
528: AND pasg.assignment_type = 'A'

Line 541: FROM per_all_assignments_f pasg ,

537: --
538: union
539: --
540: SELECT DISTINCT pasg.vacancy_id,pasg.assignment_id,'IN_PROGRESS_APPLICATIONS'
541: FROM per_all_assignments_f pasg ,
542: irc_assignment_statuses ias,
543: per_assignment_status_types past
544: WHERE pasg.vacancy_id = l_vacancy_id
545: AND pasg.assignment_type = 'A'

Line 558: FROM per_all_assignments_f pasg,

554: --
555: union
556: --
557: SELECT DISTINCT pasg.vacancy_id,pasg.assignment_id,'REJECTED_APPLICATIONS'
558: FROM per_all_assignments_f pasg,
559: per_assignment_status_types past
560: WHERE pasg.vacancy_id = l_vacancy_id
561: AND pasg.assignment_status_type_id = past.assignment_status_type_id
562: AND pasg.assignment_type = 'A'

Line 563: AND pasg.effective_end_date = (select max(paf2.effective_end_date) from per_all_assignments_f paf2 where paf2.assignment_id = pasg.assignment_id)

559: per_assignment_status_types past
560: WHERE pasg.vacancy_id = l_vacancy_id
561: AND pasg.assignment_status_type_id = past.assignment_status_type_id
562: AND pasg.assignment_type = 'A'
563: AND pasg.effective_end_date = (select max(paf2.effective_end_date) from per_all_assignments_f paf2 where paf2.assignment_id = pasg.assignment_id)
564: AND pasg.effective_end_date <= trunc(sysdate)
565: AND past.per_system_status <> 'ACCEPTED'
566: --
567: union

Line 734: FROM per_all_assignments_f pasg,

730: --
731: insert into irc_vac_summary_details (vacancy_id,assignment_id,summary_type)
732: --
733: SELECT DISTINCT ivs.vacancy_id,pasg.assignment_id,'TOTAL_APPLICATIONS'
734: FROM per_all_assignments_f pasg,
735: irc_vac_summary ivs
736: WHERE pasg.assignment_type = 'A'
737: AND pasg.vacancy_id = ivs.vacancy_id
738: AND ivs.rowid between p_start_rowid and p_end_rowid

Line 743: FROM per_all_assignments_f pasg,

739: --
740: union
741: --
742: SELECT DISTINCT ivs.vacancy_id,pasg.assignment_id,'ACTIVE_APPLICATIONS'
743: FROM per_all_assignments_f pasg,
744: irc_vac_summary ivs
745: WHERE pasg.assignment_type = 'A'
746: AND pasg.vacancy_id = ivs.vacancy_id
747: AND trunc(sysdate) between pasg.effective_start_date and pasg.effective_end_date

Line 753: FROM per_all_assignments_f pasg,

749: --
750: union
751: --
752: SELECT DISTINCT ivs.vacancy_id,pasg.assignment_id,'FILLED_APPLICATIONS'
753: FROM per_all_assignments_f pasg,
754: irc_vac_summary ivs
755: WHERE pasg.assignment_type IN ('E','C')
756: AND pasg.vacancy_id = ivs.vacancy_id
757: AND ivs.rowid between p_start_rowid and p_end_rowid

Line 762: FROM per_all_assignments_f pasg,

758: --
759: union
760: --
761: SELECT DISTINCT ivla.vacancy_id,ivla.src_apl_asg_id,'FILLED_APPLICATIONS'
762: FROM per_all_assignments_f pasg,
763: per_vac_linked_assignments ivla,
764: irc_vac_summary ivs
765: WHERE ivla.vacancy_id = ivs.vacancy_id
766: AND sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate)

Line 774: FROM per_all_assignments_f pasg ,

770: --
771: union
772: --
773: SELECT DISTINCT ivs.vacancy_id,pasg.assignment_id,'TO_BE_PROCESSED_APPLICATIONS'
774: FROM per_all_assignments_f pasg ,
775: irc_assignment_statuses ias,
776: per_assignment_status_types past,
777: irc_vac_summary ivs
778: WHERE pasg.vacancy_id = ivs.vacancy_id

Line 793: FROM per_all_assignments_f pasg ,

789: --
790: union
791: --
792: SELECT DISTINCT ivs.vacancy_id,pasg.assignment_id,'IN_PROGRESS_APPLICATIONS'
793: FROM per_all_assignments_f pasg ,
794: irc_assignment_statuses ias,
795: per_assignment_status_types past,
796: irc_vac_summary ivs
797: WHERE pasg.vacancy_id = ivs.vacancy_id

Line 812: FROM per_all_assignments_f pasg,

808: --
809: union
810: --
811: SELECT DISTINCT ivs.vacancy_id,pasg.assignment_id,'REJECTED_APPLICATIONS'
812: FROM per_all_assignments_f pasg,
813: per_assignment_status_types past,
814: irc_vac_summary ivs
815: WHERE pasg.vacancy_id = ivs.vacancy_id
816: AND pasg.assignment_status_type_id = past.assignment_status_type_id

Line 818: AND pasg.effective_end_date = (select max(paf2.effective_end_date) from per_all_assignments_f paf2 where paf2.assignment_id = pasg.assignment_id)

814: irc_vac_summary ivs
815: WHERE pasg.vacancy_id = ivs.vacancy_id
816: AND pasg.assignment_status_type_id = past.assignment_status_type_id
817: AND pasg.assignment_type = 'A'
818: AND pasg.effective_end_date = (select max(paf2.effective_end_date) from per_all_assignments_f paf2 where paf2.assignment_id = pasg.assignment_id)
819: AND pasg.effective_end_date <= trunc(sysdate)
820: AND past.per_system_status <> 'ACCEPTED'
821: AND ivs.rowid between p_start_rowid and p_end_rowid
822: --