[Home] [Help]
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';
755: FROM per_absence_attendance_types paat
756: , per_absence_attendances pab
757: , pay_payroll_actions ppa
758: , per_all_assignments_f paa
759: , per_all_people_f pap
760: WHERE paat.absence_category = 'S'
761: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
762: AND paat.business_group_id = pab.business_group_id
763: AND (pab.date_end + 1) BETWEEN p_start_date
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
797: AND nvl (posv.date_to, hr_general.end_of_time) >= p_start_date
798: AND (
843: , pab.absence_attendance_id abs_att_id
844: FROM per_absence_attendance_types paat
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
896: paa.assignment_id assignment_id
897: FROM pay_action_information pai
898: , pay_payroll_actions ppa
899: , per_all_assignments_f paa
900: , per_all_people_f pap
901: WHERE pai.action_context_type = 'AAP'
902: AND pai.action_information_category = 'NL_LTSRR_ABS_INFO'
903: AND pai.action_information4 = 'LTSRR'
904: AND pai.action_information29 = 'NL_LTSRR'
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
945: AND nvl (posv.date_to
946: ,hr_general.end_of_time) >= p_start_date
997: SELECT DISTINCT
998: paa.assignment_id assignment_id
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
1273: ,pap.person_id person_id
1274: ,pap.business_group_id bg_id
1275: ,pas.establishment_id establishment_id
1276: ,pas.assignment_sequence asg_seq
1277: FROM per_all_people_f pap
1278: ,per_all_assignments_f pas
1279: WHERE pas.assignment_id = p_assignment_id
1280: AND p_start_date BETWEEN pas.effective_start_date
1281: AND pas.effective_end_date
1681: WHERE organization_id = p_org_id;
1682:
1683: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1684: SELECT full_name
1685: FROM per_all_people_f
1686: WHERE person_id = p_person_id;
1687:
1688: BEGIN
1689: hr_utility.trace('+====gen_header_xml========================================+');