[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
788: , pab.absence_attendance_id abs_att_id
789: FROM per_absence_attendance_types paat
790: , per_absence_attendances pab
791: , pay_payroll_actions ppa
792: , per_org_structure_versions posv
793: , per_all_assignments_f paa
794: , per_all_people_f pap
795: WHERE posv.organization_structure_id = p_org_struct_id
796: AND posv.date_from <= p_end_date
845: , per_absence_attendances pab
846: , per_all_assignments_f paa
847: , per_all_people_f pap
848: , pay_payroll_actions ppa
849: , per_org_structure_versions posv
850: WHERE posv.organization_structure_id = p_org_struct_id
851: AND pap.person_id BETWEEN p_start_person_id
852: AND p_end_person_id
853: AND pap.business_group_id = ppa.business_group_id
936: SELECT DISTINCT
937: paa.assignment_id assignment_id
938: FROM pay_action_information pai
939: , pay_payroll_actions ppa
940: , per_org_structure_versions posv
941: , per_all_assignments_f paa
942: , per_all_people_f pap
943: WHERE posv.organization_structure_id = p_org_struct_id
944: AND posv.date_from <= p_end_date
999: FROM pay_action_information pai
1000: , per_all_assignments_f paa
1001: , per_all_people_f pap
1002: , pay_payroll_actions ppa
1003: , per_org_structure_versions posv
1004: WHERE posv.organization_structure_id = p_org_struct_id
1005: AND pap.person_id BETWEEN p_start_person_id
1006: AND p_end_person_id
1007: AND pap.business_group_id = ppa.business_group_id
1173: , hoi.org_information4 tax_reg
1174: FROM per_all_assignments_f pas
1175: , hr_organization_units hou
1176: , hr_organization_information hoi
1177: , per_org_structure_versions posv
1178: WHERE posv.organization_structure_id = p_org_struct_id
1179: AND p_abs_start_date BETWEEN posv.date_from
1180: AND nvl (posv.date_to
1181: ,hr_general.end_of_time)