APPS.IRC_RECRUITMENT_SUMMARY_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 346: per_assignment_status_types

342: (
343: select
344: assignment_status_type_id
345: from
346: per_assignment_status_types
347: where per_system_status = 'TERM_ASSIGN'
348: )
349: connect by prior paf.supervisor_id = paf.person_id
350: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date

Line 358: per_assignment_status_types

354: (
355: select
356: assignment_status_type_id
357: from
358: per_assignment_status_types
359: where per_system_status = 'TERM_ASSIGN'
360: ))mgr ;
361: end loop;
362: --

Line 388: per_assignment_status_types

384: (
385: select
386: assignment_status_type_id
387: from
388: per_assignment_status_types
389: where per_system_status = 'TERM_ASSIGN'
390: )
391: connect by prior paf.supervisor_id = paf.person_id
392: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date

Line 400: per_assignment_status_types

396: (
397: select
398: assignment_status_type_id
399: from
400: per_assignment_status_types
401: where per_system_status = 'TERM_ASSIGN'
402: ))rec ;
403: end loop;
404: --

Line 526: per_assignment_status_types past

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'
529: AND pasg.assignment_id = ias.assignment_id
530: AND ias.assignment_status_type_id = past.assignment_status_type_id(+)

Line 543: per_assignment_status_types past

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'
546: AND pasg.assignment_id = ias.assignment_id
547: AND ias.assignment_status_type_id = past.assignment_status_type_id(+)

Line 559: per_assignment_status_types past

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'
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)

Line 776: per_assignment_status_types past,

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
779: AND pasg.assignment_type = 'A'
780: AND pasg.assignment_id = ias.assignment_id

Line 795: per_assignment_status_types past,

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
798: AND pasg.assignment_type = 'A'
799: AND pasg.assignment_id = ias.assignment_id

Line 813: per_assignment_status_types past,

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
817: AND pasg.assignment_type = 'A'