[Home] [Help]
48: g_min_avg_weekly_hours number := 0;
49: g_hour_change_limit number := 0;
50: g_absence_termination_limit number := 0;
51: g_report_mode varchar2 (80);
52: g_legal_employer_name hr_all_organization_units.name%type;
53: g_legal_employer_org_no hr_organization_information.org_information1%type;
54: g_no_hours_change_weeks number;
55: /* GET PARAMETER */
56: function get_parameter (
203: org.name
204: legal_employer_name, org.location_id,
205: hoi1.org_information1
206: legal_employer_org_no
207: from hr_all_organization_units org,
208: hr_organization_information hoi1
209: where org.organization_id = p_legal_employer_id
210: and hoi1.organization_id(+) = org.organization_id
211: and hoi1.org_information_context(+) = 'NO_LEGAL_EMPLOYER_DETAILS';
219: hou_lu.name
220: local_unit_name,
221: hoi_lu.org_information1
222: local_unit_org_no, hou_lu.location_id
223: from hr_all_organization_units hou_le,
224: hr_organization_information hoi_le,
225: hr_all_organization_units hou_lu,
226: hr_organization_information hoi_lu
227: where hoi_le.organization_id = hou_le.organization_id
221: hoi_lu.org_information1
222: local_unit_org_no, hou_lu.location_id
223: from hr_all_organization_units hou_le,
224: hr_organization_information hoi_le,
225: hr_all_organization_units hou_lu,
226: hr_organization_information hoi_lu
227: where hoi_le.organization_id = hou_le.organization_id
228: and hou_le.organization_id = csr_v_legal_employer_id
229: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
338: hou_lu.name
339: local_unit_name,
340: hoi_lu.org_information1
341: local_unit_org_no, hou_lu.location_id
342: from hr_all_organization_units hou_le,
343: hr_organization_information hoi_le,
344: hr_all_organization_units hou_lu,
345: hr_organization_information hoi_lu
346: where hoi_le.organization_id = hou_le.organization_id
340: hoi_lu.org_information1
341: local_unit_org_no, hou_lu.location_id
342: from hr_all_organization_units hou_le,
343: hr_organization_information hoi_le,
344: hr_all_organization_units hou_lu,
345: hr_organization_information hoi_lu
346: where hoi_le.organization_id = hou_le.organization_id
347: and hou_le.organization_id = csr_v_legal_employer_id
348: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
354: --
355: /* Cursor to get Employee Details based on the Local Unit , Start Date
356: and End Date*/
357: cursor csr_employee_details (
358: p_local_unit hr_all_organization_units.organization_id%type,
359: p_start_date date,
360: p_end_date date
361: ) is
362: select papf.person_id person_id, paaf.assignment_id,
871: /* Cursor to get all the assignment for the person except the given assignment*/
872: cursor csr_get_all_assignments
873: (p_person_id per_all_people_f.person_id%type,
874: p_assignment_id per_all_assignments_f.assignment_id%type,
875: p_local_unit hr_all_organization_units.organization_id%type)
876: is
877: select assignment_id
878: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
879: where person_id = p_person_id
883:
884: /*Cursor csr_get_assignment_details
885: (p_effective_date date,
886: p_assignment_id per_all_assignments_f.assignment_id%type,
887: p_local_unit hr_all_organization_units.organization_id%type)
888: is
889: select normal_hours,
890: hourly_salaried_code, hsc.segment3 position_code, frequency
891: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
961: collemptable emptable;
962: l_ovn number;
963: l_action_info_id number;
964: l_legal_employer_id hr_organization_units.organization_id%type;
965: l_business_group_id hr_all_organization_units.business_group_id%type;
966: l_start_date date;
967: l_end_date date;
968: l_legal_employer_id hr_organization_units.organization_id%type;
969: l_effective_date date;