[Home] [Help]
460: SELECT 1
461: FROM per_all_assignments_f paa
462: ,per_assignment_status_types past
463: ,per_all_people_f pap
464: ,per_org_structure_versions posv
465: ,per_absence_attendances pab
466: ,per_absence_attendance_types paat
467: WHERE posv.organization_structure_id = c_org_struct_id
468: AND posv.date_from <= c_start_date
507: ,c_end_date IN DATE) IS
508: SELECT 1
509: FROM per_all_assignments_f paa
510: ,per_all_people_f pap
511: ,per_org_structure_versions posv
512: ,per_absence_attendances pab
513: ,per_absence_attendance_types paat
514: WHERE posv.organization_structure_id = c_org_struct_id
515: AND posv.date_from <= c_start_date
672: AND hou1.organization_id IN
673: (
674: SELECT pose.organization_id_parent
675: FROM per_org_structure_elements pose
676: ,per_org_structure_versions posv
677: WHERE posv.org_structure_version_id = pose.org_structure_version_id
678: AND posv.organization_structure_id = c_org_struct_id
679: AND posv.date_from <= c_start_date
680: AND nvl (posv.date_to
681: ,hr_general.end_of_time) >= c_end_date
682: UNION
683: SELECT pose.organization_id_child
684: FROM per_org_structure_elements pose
685: ,per_org_structure_versions posv
686: WHERE posv.org_structure_version_id = pose.org_structure_version_id
687: AND posv.organization_structure_id = c_org_struct_id
688: AND posv.date_from <= c_start_date
689: AND nvl (posv.date_to
702: AND hou2.organization_id IN
703: (
704: SELECT pose.organization_id_parent
705: FROM per_org_structure_elements pose
706: ,per_org_structure_versions posv
707: WHERE posv.org_structure_version_id = pose.org_structure_version_id
708: AND posv.organization_structure_id = c_org_struct_id
709: AND posv.date_from <= c_start_date
710: AND nvl (posv.date_to
711: ,hr_general.end_of_time) >= c_end_date
712: UNION
713: SELECT pose.organization_id_child
714: FROM per_org_structure_elements pose
715: ,per_org_structure_versions posv
716: WHERE posv.org_structure_version_id = pose.org_structure_version_id
717: AND posv.organization_structure_id = c_org_struct_id
718: AND posv.date_from <= c_start_date
719: AND nvl (posv.date_to
917: paa.assignment_id assignment_id
918: FROM per_absence_attendance_types paat
919: ,per_absence_attendances pab
920: ,pay_payroll_actions ppa
921: ,per_org_structure_versions posv
922: ,per_all_assignments_f paa
923: ,per_all_people_f pap
924: WHERE posv.organization_structure_id = p_org_struct_id
925: AND posv.date_from <= p_end_date
973: ,per_absence_attendances pab
974: ,per_all_assignments_f paa
975: ,per_all_people_f pap
976: ,pay_payroll_actions ppa
977: ,per_org_structure_versions posv
978: WHERE posv.organization_structure_id = p_org_struct_id
979: AND pap.person_id BETWEEN p_start_person_id
980: AND p_end_person_id
981: AND pap.business_group_id = ppa.business_group_id
1063: SELECT DISTINCT
1064: paa.assignment_id assignment_id
1065: FROM pay_action_information pai
1066: ,pay_payroll_actions ppa
1067: ,per_org_structure_versions posv
1068: ,per_all_assignments_f paa
1069: ,per_all_people_f pap
1070: WHERE posv.organization_structure_id = p_org_struct_id
1071: AND posv.date_from <= p_end_date
1126: FROM pay_action_information pai
1127: ,per_all_assignments_f paa
1128: ,per_all_people_f pap
1129: ,pay_payroll_actions ppa
1130: ,per_org_structure_versions posv
1131: WHERE posv.organization_structure_id = p_org_struct_id
1132: AND pap.person_id BETWEEN p_start_person_id
1133: AND p_end_person_id
1134: AND pap.business_group_id = ppa.business_group_id
1302: ,hoi.org_information4 tax_reg
1303: FROM per_all_assignments_f pas
1304: ,hr_organization_units hou
1305: ,hr_organization_information hoi
1306: ,per_org_structure_versions posv
1307: WHERE posv.organization_structure_id = p_org_struct_id
1308: AND p_abs_start_date BETWEEN posv.date_from
1309: AND nvl (posv.date_to
1310: ,hr_general.end_of_time)