APPS.HR_NL_LAW_SAMEN_REPORT dependencies on HR_NL_CALC_TARGET_GROUP

Line 423: select distinct hr_nl_calc_target_group.get_target_group(p_person_id,

419: , P_BUSINESS_GROUP_ID NUMBER
420: ,P_PERSON_ID NUMBER
421: )
422: is
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

Line 446: ,hr_nl_calc_target_group.get_target_group(ppf.person_id,

442: is
443: select distinct paf.assignment_id assignment_id
444: ,paf.effective_start_date start_date
445: ,paf.employment_category per_type
446: ,hr_nl_calc_target_group.get_target_group(ppf.person_id,
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

Line 611: and hr_nl_calc_target_group.get_target_group(ppf.person_id,

607: and to_number(to_char(nvl(paf.effective_start_date,sysdate),'YYYY')) <= P_REPORT_YEAR - 1
608: and nvl(paf.effective_end_date,sysdate) >= to_date('31/12/' ||to_char(P_REPORT_YEAR - 1),'DD/MM/YYYY')
609: and paf.person_id = ppf.person_id
610: and ppf.BUSINESS_GROUP_ID = paf.business_group_id
611: and hr_nl_calc_target_group.get_target_group(ppf.person_id,
612: to_date('31/12/' ||to_char(P_REPORT_YEAR - 1),'DD/MM/YYYY')) = 'Y'
613: and to_date('31/12/' ||to_char(P_REPORT_YEAR - 1),'DD/MM/YYYY') between ppf.effective_start_date and ppf.effective_end_date;
614:
615:

Line 687: select hr_nl_calc_target_group.get_target_group(ppf.person_id,

683: loop -- get_terminations
684:
685: l_terminated := l_terminated + 1;
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