eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_HK_IR56_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 101: -- 30 May 2003 kaverma 2920731 Replaced tables per_all_assignments_f and per_all_people_f by secured views

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

Line 140: g_employee_number per_all_people_f.employee_number%TYPE;

136: g_error_in_quarter BOOLEAN := FALSE;
137: g_business_group_id hr_organization_units.business_group_id%TYPE; -- for submitting the PAYHKCTL report
138:
139: --* Bug 2189137
140: g_employee_number per_all_people_f.employee_number%TYPE;
141:
142: TYPE
143: archive_rec IS RECORD (item_name Varchar2(100),
144: item_value Varchar2(100));

Line 191: p_start_person_id in per_all_people_f.person_id%TYPE,

187: -- processing for the Legal Entity within the Reporting Year.
188: ------------------------------------------------------------------------
189: PROCEDURE assignment_action_code
190: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
191: p_start_person_id in per_all_people_f.person_id%TYPE,
192: p_end_person_id in per_all_people_f.person_id%TYPE,
193: p_chunk in number)
194: IS
195: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 192: p_end_person_id in per_all_people_f.person_id%TYPE,

188: ------------------------------------------------------------------------
189: PROCEDURE assignment_action_code
190: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
191: p_start_person_id in per_all_people_f.person_id%TYPE,
192: p_end_person_id in per_all_people_f.person_id%TYPE,
193: p_chunk in number)
194: IS
195: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
196: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 256: c_fin_end_date. Removed per_all_people_f table and related joins modified.Checks with effective_date

252: ORDER BY pac.assignment_id;
253:
254:
255: /* Bug No : 2740270 - Modified cursor process_assignments. Included two in parameters c_fin_start_date and
256: c_fin_end_date. Removed per_all_people_f table and related joins modified.Checks with effective_date
257: modified with the new in parameters.Inner query modified to include joins with report type
258: 'HK_IR56B_ARCHIVE' and action status with 'C' and action type with 'X'.Selection of assignments ids
259: is now done through a cursor check_run and hence that part of the query has been removed from process
260: assignments */

Line 269: c_start_person_id in per_all_people_f.person_id%TYPE,

265: check for whether IR56F or IR56G is run becomes invalid hence this check is removed. */
266:
267: CURSOR process_assignments
268: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
269: c_start_person_id in per_all_people_f.person_id%TYPE,
270: c_end_person_id in per_all_people_f.person_id%TYPE,
271: c_fin_start_date in date,
272: c_fin_end_date in date,
273: c_business_group_id pay_payroll_actions.business_group_id%TYPE,

Line 270: c_end_person_id in per_all_people_f.person_id%TYPE,

266:
267: CURSOR process_assignments
268: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
269: c_start_person_id in per_all_people_f.person_id%TYPE,
270: c_end_person_id in per_all_people_f.person_id%TYPE,
271: c_fin_start_date in date,
272: c_fin_end_date in date,
273: c_business_group_id pay_payroll_actions.business_group_id%TYPE,
274: c_legal_entity_id hr_organization_units.organization_id%TYPE,

Line 490: CURSOR ir56_Spouse_info(c_person_id per_all_people_f.person_id%TYPE,

486: --* From above employee_info cursor, if contact_type ='S'
487: --* and and pcr.person_id is not null,then open cursor to
488: --* spouse details
489:
490: CURSOR ir56_Spouse_info(c_person_id per_all_people_f.person_id%TYPE,
491: c_reporting_year Varchar2 )
492: IS
493: SELECT papf_spouse.last_name
494: || DECODE(papf_spouse.first_name, null, null, ', '

Line 1392: l_employee_number per_all_people_f.employee_number%TYPE;

1388: BETWEEN a.effective_start_date AND a.effective_end_date
1389: AND NVL(sck.segment3, 'Y') = 'N';
1390:
1391:
1392: l_employee_number per_all_people_f.employee_number%TYPE;
1393:
1394: Begin
1395: --* Find whether person is manually excluded
1396: OPEN Get_ManualExclusion(g_assignment_id);

Line 1488: v_person_id per_all_people_f.person_id%TYPE;

1484: PROCEDURE archive_code
1485: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1486: p_effective_date in date)
1487: IS
1488: v_person_id per_all_people_f.person_id%TYPE;
1489: v_assignment_id per_all_assignments_f.assignment_id%TYPE;
1490: v_business_group_id hr_organization_units.business_group_id%TYPE;
1491: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;
1492: v_reporting_year varchar2(4);