[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
538: AND hou1.organization_id IN
539: (
540: SELECT pose.organization_id_parent
541: FROM per_org_structure_elements pose
542: ,per_org_structure_versions posv
543: WHERE posv.org_structure_version_id = pose.org_structure_version_id
544: AND posv.organization_structure_id = c_org_struct_id
545: AND posv.date_from <= c_start_date
546: AND nvl (posv.date_to
547: ,hr_general.end_of_time) >= c_end_date
548: UNION
549: SELECT pose.organization_id_child
550: FROM per_org_structure_elements pose
551: ,per_org_structure_versions posv
552: WHERE posv.org_structure_version_id = pose.org_structure_version_id
553: AND posv.organization_structure_id = c_org_struct_id
554: AND posv.date_from <= c_start_date
555: AND nvl (posv.date_to
568: AND hou2.organization_id IN
569: (
570: SELECT pose.organization_id_parent
571: FROM per_org_structure_elements pose
572: ,per_org_structure_versions posv
573: WHERE posv.org_structure_version_id = pose.org_structure_version_id
574: AND posv.organization_structure_id = c_org_struct_id
575: AND posv.date_from <= c_start_date
576: AND nvl (posv.date_to
577: ,hr_general.end_of_time) >= c_end_date
578: UNION
579: SELECT pose.organization_id_child
580: FROM per_org_structure_elements pose
581: ,per_org_structure_versions posv
582: WHERE posv.org_structure_version_id = pose.org_structure_version_id
583: AND posv.organization_structure_id = c_org_struct_id
584: AND posv.date_from <= c_start_date
585: AND nvl (posv.date_to
782: paa.assignment_id assignment_id
783: FROM per_absence_attendance_types paat
784: ,per_absence_attendances pab
785: ,pay_payroll_actions ppa
786: ,per_org_structure_versions posv
787: ,per_all_assignments_f paa
788: ,per_all_people_f pap
789: WHERE posv.organization_structure_id = p_org_struct_id
790: AND posv.date_from <= p_end_date
838: ,per_absence_attendances pab
839: ,per_all_assignments_f paa
840: ,per_all_people_f pap
841: ,pay_payroll_actions ppa
842: ,per_org_structure_versions posv
843: WHERE posv.organization_structure_id = p_org_struct_id
844: AND pap.person_id BETWEEN p_start_person_id
845: AND p_end_person_id
846: 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
1165: ,hoi.org_information4 tax_reg
1166: FROM per_all_assignments_f pas
1167: ,hr_organization_units hou
1168: ,hr_organization_information hoi
1169: ,per_org_structure_versions posv
1170: WHERE posv.organization_structure_id = p_org_struct_id
1171: AND p_abs_start_date BETWEEN posv.date_from
1172: AND nvl (posv.date_to
1173: ,hr_general.end_of_time)