[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
645: ,sqlstr OUT NOCOPY VARCHAR2) is
646: BEGIN
647: hr_utility.trace('+====range_code============================================+');
648: sqlstr := 'SELECT DISTINCT person_id
649: FROM per_all_people_f pap
650: ,pay_payroll_actions ppa
651: WHERE ppa.payroll_action_id = :payroll_action_id
652: AND ppa.business_group_id = pap.business_group_id
653: ORDER BY pap.person_id';
750: FROM per_absence_attendance_types paat
751: ,per_absence_attendances pab
752: ,pay_payroll_actions ppa
753: ,per_all_assignments_f paa
754: ,per_all_people_f pap
755: WHERE paat.absence_category = 'S'
756: AND paat.absence_attendance_type_id = pab.absence_attendance_type_id
757: AND paat.business_group_id = pab.business_group_id
758: AND pab.date_start BETWEEN p_start_date
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
791: AND nvl (posv.date_to,hr_general.end_of_time) >= p_start_date
792: AND (
836: paa.assignment_id assignment_id
837: FROM per_absence_attendance_types paat
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
888: paa.assignment_id assignment_id
889: FROM pay_action_information pai
890: ,pay_payroll_actions ppa
891: ,per_all_assignments_f paa
892: ,per_all_people_f pap
893: WHERE pai.action_context_type = 'AAP'
894: AND pai.action_information_category = 'NL_LTSR_ABS_INFO'
895: AND pai.action_information4 = 'LTSR'
896: AND pai.action_information29 = 'NL_LTSR'
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
937: AND nvl (posv.date_to
938: ,hr_general.end_of_time) >= p_start_date
989: SELECT DISTINCT
990: paa.assignment_id assignment_id
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
1275: ,pap.person_id person_id
1276: ,pap.business_group_id bg_id
1277: ,pas.establishment_id establishment_id
1278: ,pas.assignment_sequence asg_seq
1279: FROM per_all_people_f pap
1280: ,per_all_assignments_f pas
1281: WHERE pas.assignment_id = p_assignment_id
1282: AND p_start_date BETWEEN pas.effective_start_date
1283: AND pas.effective_end_date
1611: WHERE organization_id = p_org_id;
1612:
1613: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1614: SELECT full_name
1615: FROM per_all_people_f
1616: WHERE person_id = p_person_id;
1617:
1618: BEGIN
1619: hr_utility.trace('+====gen_header_xml========================================+');