[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
274: c_legal_entity_id hr_organization_units.organization_id%TYPE,
275: c_reporting_year NUMBER)
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
438: NVL(pcr.contact_person_id,0) person_id, -- used in spouse cursor
439: pcr.contact_type contact_type, -- used in spouse cursor
440: pcr.date_start date_start
441: FROM per_people_f papf,
442: per_assignments_f paaf,
443: fnd_territories_tl ftv, /* Bug No : 3059915 */
444: per_contact_relationships pcr,
445: per_addresses pad,
446: per_assignment_extra_info paei,
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
1019: AND paa.period_of_service_id = pps.period_of_service_id /* Bug No : 2824718 */
1266: DECODE(sex, 'F', NVL(previous_last_name, last_name), last_name)
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
1377:
1378: Cursor Get_ManualExclusion(p_assignment_id per_all_assignments_f.assignment_id%TYPE)
1379: IS
1380: SELECT pap.employee_number
1381: FROM per_assignments_f a,
1382: hr_soft_coding_keyflex sck,
1383: per_people_f pap
1384: WHERE a.assignment_id = p_assignment_id
1385: AND a.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1502: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1503: effective_date
1504: FROM pay_payroll_actions ppa,
1505: pay_assignment_actions pac,
1506: per_assignments_f paa
1507: WHERE pac.assignment_action_id = c_assignment_action_id
1508: AND ppa.payroll_action_id = pac.payroll_action_id
1509: AND paa.assignment_id = pac.assignment_id;
1510: