[Home] [Help]
1023: , per_recruitment_activity_for RAF
1024: , per_recruitment_activities pra
1025: , irc_posting_contents ipc
1026: , irc_all_recruiting_sites iars
1027: , per_all_people_f ppf
1028: , per_phones pp
1029: where pv.vacancy_id = raf.vacancy_id
1030: and pv.status='APPROVED'
1031: and raf.recruitment_activity_id = pra.recruitment_activity_id
1035: and pv.recruiter_id = ppf.person_id
1036: and sysdate between ppf.effective_start_date
1037: and ppf.effective_end_date
1038: and pv.recruiter_id = pp.parent_id(+)
1039: and pp.parent_table(+)='PER_ALL_PEOPLE_F'
1040: and pp.phone_type(+)='W1'
1041: and sysdate between nvl(pp.date_from, sysdate) and nvl(pp.date_to, sysdate)
1042: and ( nvl(ipc.recruiter_full_name,'-1') <> ppf.full_name
1043: OR nvl(ipc.recruiter_email,'-1') <> nvl(ppf.email_address,'-1')
1054: , per_recruitment_activity_for RAF
1055: , per_recruitment_activities pra
1056: , irc_posting_contents ipc
1057: , irc_all_recruiting_sites iars
1058: , per_all_people_f ppf
1059: , per_phones pp
1060: where pv.vacancy_id = raf.vacancy_id
1061: and pv.status='APPROVED'
1062: and raf.recruitment_activity_id = pra.recruitment_activity_id
1066: and pv.manager_id = ppf.person_id
1067: and sysdate between ppf.effective_start_date
1068: and ppf.effective_end_date
1069: and pv.recruiter_id = pp.parent_id(+)
1070: and pp.parent_table(+)='PER_ALL_PEOPLE_F'
1071: and pp.phone_type(+)='W1'
1072: and sysdate between nvl(pp.date_from, sysdate) and nvl(pp.date_to, sysdate)
1073: and ( nvl(ipc.manager_full_name,'-1') <> ppf.full_name
1074: OR nvl(ipc.manager_email,'-1') <> nvl(ppf.email_address,'-1')