eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NL_LAW_SAMEN_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 408: from per_all_assignments_f paf

404: is
405:
406: select distinct paf.assignment_id assignment_id
407: ,paf.person_id
408: from per_all_assignments_f paf
409:
410: where paf.organization_id = p_organization_id_child
411: and paf.business_group_id = P_BUSINESS_GROUP_ID
412: and paf.assignment_type = 'E'

Line 450: from per_all_assignments_f paf

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

Line 600: from per_all_assignments_f paf

596: end loop;
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