APPS.HR_NL_LAW_SAMEN_REPORT dependencies on PER_PEOPLE_F

Line 427: from per_people_f ppf1

423: select distinct hr_nl_calc_target_group.get_target_group(p_person_id,
424: to_date('31/12/' ||to_char(P_REPORT_YEAR),'DD/MM/YYYY'))
425: allochth
426: ,ppf1.per_information7 objection
427: from per_people_f ppf1
428: where ppf1.business_group_id = P_BUSINESS_GROUP_ID
429: and to_number(to_char(nvl(ppf1.effective_start_date,sysdate),'YYYY')) <= P_REPORT_YEAR
430: and to_number(to_char(nvl(ppf1.effective_end_date,sysdate),'YYYY')) >= P_REPORT_YEAR
431: and ppf1.person_id = P_PERSON_ID

Line 451: , per_people_f ppf

447: to_date('31/12/' ||to_char(P_REPORT_YEAR),'DD/MM/YYYY')) allochth
448: ,ppf.per_information7 objection
449:
450: from per_all_assignments_f paf
451: , per_people_f ppf
452:
453: where paf.organization_id = p_organization_id_child
454: and paf.business_group_id = P_BUSINESS_GROUP_ID
455: and paf.assignment_type = 'E'

Line 601: , per_people_f ppf

597:
598: select count(1)
599: into l_last_acht_total
600: from per_all_assignments_f paf
601: , per_people_f ppf
602:
603: where paf.organization_id = P_ORGANIZATION_ID
604: and paf.business_group_id = P_BUSINESS_GROUP_ID
605: and paf.assignment_type = 'E'

Line 690: from per_people_f ppf

686:
687: select hr_nl_calc_target_group.get_target_group(ppf.person_id,
688: to_date('31/12/'||to_char(P_REPORT_YEAR),'DD/MM/YYYY')) allochth
689: into l_acht
690: from per_people_f ppf
691: where ppf.person_id = term_rec.person_id
692: and to_date('31/12/' ||to_char(P_REPORT_YEAR),'DD/MM/YYYY') between ppf.effective_start_date and ppf.effective_end_date;
693:
694: