APPS.PAY_HK_IR56_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 62: -- per_periods_of_service tables and related joins. quarters_period_start

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.
66: -- 10 Feb 2003 puchil 2778848 Changed the effective date check in cursor process_assignments

Line 263: eliminate the terminated employee details, by including per_periods_of_service and checking

259: is now done through a cursor check_run and hence that part of the query has been removed from process
260: assignments */
261:
262: /*Bug No : 2778848 - Modified cursor process_assignments, the select statement is changed to
263: eliminate the terminated employee details, by including per_periods_of_service and checking
264: for the existance of assignment as of 31 of march. Since terminated employees are not selected, the
265: check for whether IR56F or IR56G is run becomes invalid hence this check is removed. */
266:
267: CURSOR process_assignments

Line 280: per_periods_of_service pps

276: IS
277: SELECT DISTINCT a.assignment_id assignment_id
278: FROM per_assignments_f a,
279: pay_payroll_actions pa,
280: per_periods_of_service pps
281: WHERE pa.payroll_action_id = c_payroll_action_id
282: AND a.person_id BETWEEN c_start_person_id and c_end_person_id
283: AND a.business_group_id = pa.business_group_id
284: AND TO_DATE('31-03-'||c_reporting_year, 'DD-MM-YYYY') between a.effective_start_date and a.effective_end_date

Line 447: per_periods_of_service pps,

443: fnd_territories_tl ftv, /* Bug No : 3059915 */
444: per_contact_relationships pcr,
445: per_addresses pad,
446: per_assignment_extra_info paei,
447: per_periods_of_service pps,
448: hr_soft_coding_keyflex hsck,
449: hr_lookups hrl
450: WHERE paaf.person_id = papf.person_id
451: AND TO_DATE('31-03-'|| c_reporting_year, 'DD-MM-YYYY')

Line 1014: per_periods_of_service pps,

1010: max(b.QUARTERS_EE_TO_LANDLORD) QUARTERS_EE_TO_LANDLORD,
1011: max(b.QUARTERS_REFUND_TO_EE) QUARTERS_REFUND_TO_EE,
1012: max(b.QUARTERS_EE_TO_ER) QUARTERS_EE_TO_ER
1013: FROM pay_hk_ir56_quarters_info_v b,
1014: per_periods_of_service pps,
1015: per_assignments_f paa
1016: WHERE b.assignment_id = c_assignment_id
1017: AND paa.assignment_id = b.assignment_id
1018: AND paa.person_id = pps.person_id

Line 1271: per_periods_of_service pps

1267: ,last_name) last_name,
1268: TRIM(papf.first_name||' '||papf.middle_names) other_name
1269: FROM per_people_f papf,
1270: per_assignments_f paaf,
1271: per_periods_of_service pps
1272: WHERE paaf.person_id = papf.person_id
1273: AND TO_DATE('31-03-'|| c_reporting_year, 'DD-MM-YYYY')
1274: BETWEEN paaf.effective_start_date and paaf.effective_end_date
1275: AND TO_DATE('31-03-'|| c_reporting_year, 'DD-MM-YYYY')