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 142: g_employee_number per_all_people_f.employee_number%TYPE;

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

Line 193: p_start_person_id in per_all_people_f.person_id%TYPE,

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

Line 194: p_end_person_id in per_all_people_f.person_id%TYPE,

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

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

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

Line 271: c_start_person_id in per_all_people_f.person_id%TYPE,

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

Line 272: c_end_person_id in per_all_people_f.person_id%TYPE,

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

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

521: --* From above employee_info cursor, if contact_type ='S'
522: --* and and pcr.person_id is not null,then open cursor to
523: --* spouse details
524:
525: CURSOR ir56_Spouse_info(c_person_id per_all_people_f.person_id%TYPE,
526: c_reporting_year Varchar2 )
527: IS
528: SELECT papf_spouse.last_name
529: || DECODE(papf_spouse.first_name, null, null, ', '

Line 1461: l_employee_number per_all_people_f.employee_number%TYPE;

1457: BETWEEN a.effective_start_date AND a.effective_end_date
1458: AND NVL(sck.segment3, 'Y') = 'N';
1459:
1460:
1461: l_employee_number per_all_people_f.employee_number%TYPE;
1462:
1463: Begin
1464: --* Find whether person is manually excluded
1465: OPEN Get_ManualExclusion(g_assignment_id);

Line 1557: v_person_id per_all_people_f.person_id%TYPE;

1553: PROCEDURE archive_code
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);