[Home] [Help]
362: select papf.person_id person_id, paaf.assignment_id,
363: papf.effective_start_date, null effective_end_date, null emp_end_date,
364: national_identifier, full_name, employee_number, normal_hours,
365: hourly_salaried_code, hsc.segment3 position_code, frequency
366: from per_all_people_f papf,
367: per_all_assignments_f paaf,
368: hr_soft_coding_keyflex hsc,
369: per_assignment_status_types past
370: where papf.person_id between p_start_person and p_end_person
397: select papf.person_id person_id, paaf.assignment_id,
398: papf.effective_start_date, paaf.effective_end_date, papf.effective_end_date emp_end_date,
399: national_identifier, full_name, employee_number, normal_hours,
400: hourly_salaried_code, hsc.segment3 position_code, frequency
401: from per_all_people_f papf,
402: per_all_assignments_f paaf,
403: hr_soft_coding_keyflex hsc,
404: per_assignment_status_types past
405: where paaf.person_id = papf.person_id
445: --
446: /* Cursor to get the Absence Start Date and End Date when employee is on
447: absence for more than 14 days */
448: cursor csr_absence_start_days (
449: p_person_id per_all_people_f.person_id%type
450: ) is
451: select paa.date_start, paa.date_end
452: from per_absence_attendances paa, per_absence_attendance_types paat
453: where paat.absence_attendance_type_id =
458: and paat.absence_category not in
459: ('S', 'PTM', 'PTS', 'PTP', 'PTA', 'VAC', 'MRE'); /* 5520062 5648385 */
460:
461: cursor csr_absence_end_days (
462: p_person_id per_all_people_f.person_id%type
463: ,p_prev_last_date date
464: ) is
465: select paa.date_start, paa.date_end
466: from per_absence_attendances paa, per_absence_attendance_types paat
703: -- order by effective_start_date desc ;
704:
705: /* Cursor to get all the assignment for the person except the given assignment*/
706: cursor csr_get_all_assignments
707: (p_person_id per_all_people_f.person_id%type,
708: p_assignment_id per_all_assignments_f.assignment_id%type,
709: p_local_unit hr_all_organization_units.organization_id%type)
710: is
711: select assignment_id
802: l_legal_employer_id hr_organization_units.organization_id%type;
803: l_effective_date date;
804: l_emp_start_date date;
805: l_emp_end_date date;
806: l_person_id per_all_people_f.person_id%type;
807: l_event_group_id pay_event_groups.event_group_id%type;
808: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
809: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
810: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
869: l_prev_hour_value_primary number;
870: l_prev_hour_eff_date date;
871: l_lu_change_flag char (1); /* 5519990 */
872: l_local_unit_org_no hr_organization_information.org_information1%type; /* 5519990 */
873: l_national_identifier per_all_people_f.national_identifier%type; /* 5526181 */
874: l_old_date date;
875: l_curr_hours number;
876: l_curr_frequency per_all_assignments_f.frequency%type;
877: l_eff_end_date_need char (1);
2835: end;
2836:
2837: function get_assignment_all_hours (
2838: p_assignment_id in per_all_assignments_f.assignment_id%type,
2839: p_person_id in per_all_people_f.person_id%type,
2840: p_effective_date in date,
2841: p_primary_hour_value number,
2842: p_local_unit number
2843: )
2852: and p_effective_date between effective_start_date
2853: and effective_end_date;
2854:
2855: cursor csr_all_assignments_hours (
2856: p_person_id per_all_people_f.person_id%type,
2857: p_assignment_id per_all_assignments_f.assignment_id%type,
2858: p_effective_date date,
2859: p_local_unit number
2860: ) is
3402: function check_national_identifier (
3403: p_national_identifier varchar2
3404: )
3405: return varchar2 is
3406: l_return_value per_all_people_f.national_identifier%type;
3407: l_check_value number;
3408: d1 number;
3409: d2 number;
3410: m1 number;