[Home] [Help]
57: -- section.
58: -- 22 Jan 2003 puchil 2762276 Modified the cursor ir56_employee_info to select area_code_res
59: -- and modified tab_empl(8).item_value ('X_HK_RESIDENTIAL_ADDRESS_AREA_CODE')
60: -- to archive area_code_res instead of town_or_city if address_type is 'HK_R'
61: -- 24 Jan 2003 srrajago 2760137 Cursor quarters_info modified to include per_all_assignments_f and
62: -- per_periods_of_service tables and related joins. quarters_period_start
63: -- and quarters_period_end have also been modified.
64: -- 27 Jan 2003 srrajago 2760137 Included nvl check for actual_termination_date in the field
65: -- quarters_period_end of the cursor quarters_info.
97: -- 07 May 2003 shoskatt 2945151 Changed the cursor ir56_employee_info to fetch chinese_full_name. This was
98: -- removed w.r.t earlier fix (Bug# 2942797)
99: -- 08 May 2003 srrajago 2853776 Removed the financial year condition check from the main part of the
100: -- cursor quarters_info and included the same in the sub-query.
101: -- 30 May 2003 kaverma 2920731 Replaced tables per_all_assignments_f and per_all_people_f by secured views
102: -- per_assignments_f and per_people_f respectively form the queries
103: -- 05 Jun 2003 puchil 2949952 Archived the country value in X_HK_RES_COUNTRY
104: -- 21 Jul 2003 srrajago 3055512 Employees terminated on 31-MAR-YYYY should not be included in the archive
105: -- run for the year YYYY. Hence modified the cursor process_assignments by
207: l_counter number:=1;
208: counter number:=1;
209: t_aid per_all_assignments.assignment_id%type;
210:
211: TYPE t_assignment_list IS TABLE OF per_all_assignments_f.assignment_id%type;
212: asglist t_assignment_list;
213:
214:
215: CURSOR next_action_id is
1443:
1444: Function Validate_Employee(p_reporting_year IN Varchar2) Return Number
1445: IS
1446:
1447: Cursor Get_ManualExclusion(p_assignment_id per_all_assignments_f.assignment_id%TYPE)
1448: IS
1449: SELECT pap.employee_number
1450: FROM per_assignments_f a,
1451: hr_soft_coding_keyflex sck,
1554: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1555: p_effective_date in date)
1556: IS
1557: v_person_id per_all_people_f.person_id%TYPE;
1558: v_assignment_id per_all_assignments_f.assignment_id%TYPE;
1559: v_business_group_id hr_organization_units.business_group_id%TYPE;
1560: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;
1561: v_reporting_year varchar2(4);
1562: v_archive_date pay_payroll_actions.effective_date%TYPE;