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
519: AND pasg.assignment_type IN ('E','C')
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)
767: AND ivla.tgt_apl_asg_id = pasg.assignment_id