[Home] [Help]
330: SELECT 1
331: FROM per_all_assignments_f paa
332: ,per_assignment_status_types past
333: ,per_all_people_f pap
334: ,per_org_structure_versions posv
335: ,per_absence_attendances pab
336: ,per_absence_attendance_types paat
337: WHERE posv.organization_structure_id = c_org_struct_id
338: AND posv.date_from <= c_start_date
376: ,c_end_date IN DATE) IS
377: SELECT 1
378: FROM per_all_assignments_f paa
379: ,per_all_people_f pap
380: ,per_org_structure_versions posv
381: ,per_absence_attendances pab
382: ,per_absence_attendance_types paat
383: WHERE posv.organization_structure_id = c_org_struct_id
384: AND posv.date_from <= c_start_date
540: AND hou1.organization_id IN
541: (
542: SELECT pose.organization_id_parent
543: FROM per_org_structure_elements pose
544: ,per_org_structure_versions posv
545: WHERE posv.org_structure_version_id = pose.org_structure_version_id
546: AND posv.organization_structure_id = c_org_struct_id
547: AND posv.date_from <= c_start_date
548: AND nvl (posv.date_to
549: ,hr_general.end_of_time) >= c_end_date
550: UNION
551: SELECT pose.organization_id_child
552: FROM per_org_structure_elements pose
553: ,per_org_structure_versions posv
554: WHERE posv.org_structure_version_id = pose.org_structure_version_id
555: AND posv.organization_structure_id = c_org_struct_id
556: AND posv.date_from <= c_start_date
557: AND nvl (posv.date_to
570: AND hou2.organization_id IN
571: (
572: SELECT pose.organization_id_parent
573: FROM per_org_structure_elements pose
574: ,per_org_structure_versions posv
575: WHERE posv.org_structure_version_id = pose.org_structure_version_id
576: AND posv.organization_structure_id = c_org_struct_id
577: AND posv.date_from <= c_start_date
578: AND nvl (posv.date_to
579: ,hr_general.end_of_time) >= c_end_date
580: UNION
581: SELECT pose.organization_id_child
582: FROM per_org_structure_elements pose
583: ,per_org_structure_versions posv
584: WHERE posv.org_structure_version_id = pose.org_structure_version_id
585: AND posv.organization_structure_id = c_org_struct_id
586: AND posv.date_from <= c_start_date
587: AND nvl (posv.date_to
784: paa.assignment_id assignment_id
785: FROM per_absence_attendance_types paat
786: ,per_absence_attendances pab
787: ,pay_payroll_actions ppa
788: ,per_org_structure_versions posv
789: ,per_all_assignments_f paa
790: ,per_all_people_f pap
791: WHERE posv.organization_structure_id = p_org_struct_id
792: AND posv.date_from <= p_end_date
839: ,per_absence_attendances pab
840: ,per_all_assignments_f paa
841: ,per_all_people_f pap
842: ,pay_payroll_actions ppa
843: ,per_org_structure_versions posv
844: WHERE posv.organization_structure_id = p_org_struct_id
845: AND pap.person_id BETWEEN p_start_person_id
846: AND p_end_person_id
847: AND pap.business_group_id = ppa.business_group_id
928: SELECT DISTINCT
929: paa.assignment_id assignment_id
930: FROM pay_action_information pai
931: ,pay_payroll_actions ppa
932: ,per_org_structure_versions posv
933: ,per_all_assignments_f paa
934: ,per_all_people_f pap
935: WHERE posv.organization_structure_id = p_org_struct_id
936: AND posv.date_from <= p_end_date
991: FROM pay_action_information pai
992: ,per_all_assignments_f paa
993: ,per_all_people_f pap
994: ,pay_payroll_actions ppa
995: ,per_org_structure_versions posv
996: WHERE posv.organization_structure_id = p_org_struct_id
997: AND pap.person_id BETWEEN p_start_person_id
998: AND p_end_person_id
999: AND pap.business_group_id = ppa.business_group_id
1168: ,hoi.org_information4 tax_reg
1169: FROM per_all_assignments_f pas
1170: ,hr_organization_units hou
1171: ,hr_organization_information hoi
1172: ,per_org_structure_versions posv
1173: WHERE posv.organization_structure_id = p_org_struct_id
1174: AND p_abs_start_date BETWEEN posv.date_from
1175: AND nvl (posv.date_to
1176: ,hr_general.end_of_time)