[Home] [Help]
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
106: -- including the join with actual_termination_date <> 31-Mar-YYYY.
110: -- # In the cursors 'ir56_Spouse_info' and 'ir56_Employee_info',view
111: -- fnd_territories_vl replaced with fnd_territories_tl table and a
112: -- join with language also included.
113: -- # In the procedure 'Archive_Excep_Error_dtls', cursor 'ir56_employer_info'
114: -- modified.Table per_assignments_f and its related joins removed.
115: -- Cursor 'ir56_Employee_info' also modified.A join with period_of_service_id
116: -- added.
117: -- 15 Dec 2003 srrajago 3193217 Modified the procedure 'archive_balance_details'. Call to the function
118: -- 'get_emoluments' and the return values substitution have been changed as package
276: c_legal_entity_id hr_organization_units.organization_id%TYPE,
277: c_reporting_year NUMBER)
278: IS
279: SELECT DISTINCT a.assignment_id assignment_id
280: FROM per_assignments_f a,
281: pay_payroll_actions pa,
282: per_periods_of_service pps
283: WHERE pa.payroll_action_id = c_payroll_action_id
284: AND a.person_id BETWEEN c_start_person_id and c_end_person_id
440: NVL(pcr.contact_person_id,0) person_id, -- used in spouse cursor
441: pcr.contact_type contact_type, -- used in spouse cursor
442: pcr.date_start date_start
443: FROM per_people_f papf,
444: per_assignments_f paaf,
445: fnd_territories_tl ftv, /* Bug No : 3059915 */
446: per_contact_relationships pcr,
447: per_addresses pad,
448: per_assignment_extra_info paei,
1080: max(b.QUARTERS_REFUND_TO_EE) QUARTERS_REFUND_TO_EE,
1081: max(b.QUARTERS_EE_TO_ER) QUARTERS_EE_TO_ER
1082: FROM pay_hk_ir56_quarters_info_v b,
1083: per_periods_of_service pps,
1084: per_assignments_f paa
1085: WHERE b.assignment_id = c_assignment_id
1086: AND paa.assignment_id = b.assignment_id
1087: AND paa.person_id = pps.person_id
1088: AND paa.period_of_service_id = pps.period_of_service_id /* Bug No : 2824718 */
1335: DECODE(sex, 'F', NVL(previous_last_name, last_name), last_name)
1336: ,last_name) last_name,
1337: TRIM(papf.first_name||' '||papf.middle_names) other_name
1338: FROM per_people_f papf,
1339: per_assignments_f paaf,
1340: per_periods_of_service pps
1341: WHERE paaf.person_id = papf.person_id
1342: AND TO_DATE('31-03-'|| c_reporting_year, 'DD-MM-YYYY')
1343: BETWEEN paaf.effective_start_date and paaf.effective_end_date
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,
1452: per_people_f pap
1453: WHERE a.assignment_id = p_assignment_id
1454: AND a.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1571: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1572: effective_date
1573: FROM pay_payroll_actions ppa,
1574: pay_assignment_actions pac,
1575: per_assignments_f paa
1576: WHERE pac.assignment_action_id = c_assignment_action_id
1577: AND ppa.payroll_action_id = pac.payroll_action_id
1578: AND paa.assignment_id = pac.assignment_id;
1579: