[Home] [Help]
79: 02-Sep-2003 meshah 115.29 3124483 using actual_termination_date instead
80: of final_prcess_date.
81: 02-Sep-2003 meshah 115.28 3124483 the cursor get_person_info in
82: get_doc_eit function has been changed.
83: Now joining to per_periods_of_service
84: to find out if the employee is
85: terminated.
86: 19-JUL-2003 ahanda 115.27 Added function format_to_date.
87: 23-May-03 ekim 115.26 2897743 Added c_get_lookup_for_paid.
1279: where hoi.organization_id = l_business_group_id
1280: and hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
1281: and hoi.org_information1 = upper(p_doc_type) ;
1282:
1283: /* adding a join to per_periods_of_service. If the employee is terminated then
1284: the person does not have access to online doc, so we should always return a
1285: N.
1286: */
1287:
1287:
1288: CURSOR get_person_info(l_assignment_id number) IS
1289: select paf.business_group_id, paf.organization_id,
1290: paf.location_id, paf.person_id
1291: from per_assignments_f paf, per_periods_of_service pps
1292: where paf.assignment_id = l_assignment_id
1293: and p_effective_date between paf.effective_start_date
1294: and paf.effective_end_date
1295: and pps.period_of_service_id = paf.period_of_service_id
1687: --get_legislation_code(p_business_group_id);
1688:
1689: cursor c_get_terminate_date is
1690: select actual_termination_date, pai.action_information16
1691: from per_periods_of_service pps,
1692: pay_action_information pai
1693: where pps.person_id = p_person_id
1694: and pai.action_context_id = p_action_context_id
1695: and pai.action_information_category = 'EMPLOYEE DETAILS'
1700: cursor c_get_term_details(p_actual_termination_date varchar2,
1701: p_time_period_id number) is
1702: /* Changed this for bug 4132132
1703: select 'Y'
1704: from per_periods_of_service pps
1705: where person_id = p_person_id
1706: and decode(actual_termination_date,NULL,date_start,p_effective_start_date)
1707: between date_start
1708: and nvl(actual_termination_date,p_effective_end_date) ;