325: ,c_end_date IN DATE) IS
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
372: ,c_start_date IN 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
646: ,sqlstr OUT NOCOPY VARCHAR2) is
647: BEGIN
648: hr_utility.trace('+====range_code============================================+');
649: sqlstr := 'SELECT DISTINCT person_id
650: FROM per_all_people_f pap
651: ,pay_payroll_actions ppa
652: WHERE ppa.payroll_action_id = :payroll_action_id
653: AND ppa.business_group_id = pap.business_group_id
654: ORDER BY pap.person_id';
753: FROM per_absence_attendance_types paat
754: , per_absence_attendances pab
755: , pay_payroll_actions ppa
756: , per_all_assignments_f paa
757: , per_all_people_f pap
758: WHERE paat.absence_category = 'S'
759: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
760: AND paat.business_group_id = pab.business_group_id
761: AND (pab.date_end + 1) BETWEEN p_start_date
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
795: AND nvl (posv.date_to, hr_general.end_of_time) >= p_start_date
796: AND (
841: , pab.absence_attendance_id abs_att_id
842: FROM per_absence_attendance_types paat
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
893: paa.assignment_id assignment_id
894: FROM pay_action_information pai
895: , pay_payroll_actions ppa
896: , per_all_assignments_f paa
897: , per_all_people_f pap
898: WHERE pai.action_context_type = 'AAP'
899: AND pai.action_information_category = 'NL_DSRR_ABS_INFO'
900: AND pai.action_information4 = 'SRR'
901: AND pai.action_information29 = 'NL_SRR'
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
942: AND nvl (posv.date_to
943: ,hr_general.end_of_time) >= p_start_date
994: SELECT DISTINCT
995: paa.assignment_id assignment_id
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
1289: ,pap.person_id person_id
1290: ,pap.business_group_id bg_id
1291: ,pas.establishment_id establishment_id
1292: ,pas.assignment_sequence asg_seq
1293: FROM per_all_people_f pap
1294: ,per_all_assignments_f pas
1295: WHERE pas.assignment_id = p_assignment_id
1296: AND p_start_date BETWEEN pas.effective_start_date
1297: AND pas.effective_end_date
1658: WHERE organization_id = p_org_id;
1659:
1660: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1661: SELECT full_name
1662: FROM per_all_people_f
1663: WHERE person_id = p_person_id;
1664:
1665: BEGIN
1666: hr_utility.trace('+====gen_header_xml========================================+');