[Home] [Help]
326: SELECT 1
327: FROM per_all_assignments_f paa
328: ,per_assignment_status_types past
329: ,per_all_people_f pap
330: ,per_org_structure_versions posv
331: ,per_absence_attendances pab
332: ,per_absence_attendance_types paat
333: WHERE posv.organization_structure_id = c_org_struct_id
334: AND posv.date_from <= c_start_date
373: ,c_end_date IN DATE) IS
374: SELECT 1
375: FROM per_all_assignments_f paa
376: ,per_all_people_f pap
377: ,per_org_structure_versions posv
378: ,per_absence_attendances pab
379: ,per_absence_attendance_types paat
380: WHERE posv.organization_structure_id = c_org_struct_id
381: AND posv.date_from <= c_start_date
539: AND hou1.organization_id IN
540: (
541: SELECT pose.organization_id_parent
542: FROM per_org_structure_elements pose
543: ,per_org_structure_versions posv
544: WHERE posv.org_structure_version_id = pose.org_structure_version_id
545: AND posv.organization_structure_id = c_org_struct_id
546: AND posv.date_from <= c_start_date
547: AND nvl (posv.date_to
548: ,hr_general.end_of_time) >= c_end_date
549: UNION
550: SELECT pose.organization_id_child
551: FROM per_org_structure_elements pose
552: ,per_org_structure_versions posv
553: WHERE posv.org_structure_version_id = pose.org_structure_version_id
554: AND posv.organization_structure_id = c_org_struct_id
555: AND posv.date_from <= c_start_date
556: AND nvl (posv.date_to
569: AND hou2.organization_id IN
570: (
571: SELECT pose.organization_id_parent
572: FROM per_org_structure_elements pose
573: ,per_org_structure_versions posv
574: WHERE posv.org_structure_version_id = pose.org_structure_version_id
575: AND posv.organization_structure_id = c_org_struct_id
576: AND posv.date_from <= c_start_date
577: AND nvl (posv.date_to
578: ,hr_general.end_of_time) >= c_end_date
579: UNION
580: SELECT pose.organization_id_child
581: FROM per_org_structure_elements pose
582: ,per_org_structure_versions posv
583: WHERE posv.org_structure_version_id = pose.org_structure_version_id
584: AND posv.organization_structure_id = c_org_struct_id
585: AND posv.date_from <= c_start_date
586: AND nvl (posv.date_to
786: , pab.absence_attendance_id abs_att_id
787: FROM per_absence_attendance_types paat
788: , per_absence_attendances pab
789: , pay_payroll_actions ppa
790: , per_org_structure_versions posv
791: , per_all_assignments_f paa
792: , per_all_people_f pap
793: WHERE posv.organization_structure_id = p_org_struct_id
794: AND posv.date_from <= p_end_date
843: , per_absence_attendances pab
844: , per_all_assignments_f paa
845: , per_all_people_f pap
846: , pay_payroll_actions ppa
847: , per_org_structure_versions posv
848: WHERE posv.organization_structure_id = p_org_struct_id
849: AND pap.person_id BETWEEN p_start_person_id
850: AND p_end_person_id
851: AND pap.business_group_id = ppa.business_group_id
933: SELECT DISTINCT
934: paa.assignment_id assignment_id
935: FROM pay_action_information pai
936: , pay_payroll_actions ppa
937: , per_org_structure_versions posv
938: , per_all_assignments_f paa
939: , per_all_people_f pap
940: WHERE posv.organization_structure_id = p_org_struct_id
941: AND posv.date_from <= p_end_date
996: FROM pay_action_information pai
997: , per_all_assignments_f paa
998: , per_all_people_f pap
999: , pay_payroll_actions ppa
1000: , per_org_structure_versions posv
1001: WHERE posv.organization_structure_id = p_org_struct_id
1002: AND pap.person_id BETWEEN p_start_person_id
1003: AND p_end_person_id
1004: AND pap.business_group_id = ppa.business_group_id
1170: ,hoi.org_information4 tax_reg
1171: FROM per_all_assignments_f pas
1172: ,hr_organization_units hou
1173: ,hr_organization_information hoi
1174: ,per_org_structure_versions posv
1175: WHERE posv.organization_structure_id = p_org_struct_id
1176: AND p_abs_start_date BETWEEN posv.date_from
1177: AND nvl (posv.date_to
1178: ,hr_general.end_of_time)