[Home] [Help]
2936:
2937: IF p_event_desc = l_event_description
2938: AND (
2939: (
2940: NVL(l_source_pension_scheme, hr_api.g_varchar2) =
2941: NVL(l_pension_scheme, hr_api.g_varchar2)
2942: )
2943: OR (
2944: l_source_pension_scheme IS NOT NULL
2937: IF p_event_desc = l_event_description
2938: AND (
2939: (
2940: NVL(l_source_pension_scheme, hr_api.g_varchar2) =
2941: NVL(l_pension_scheme, hr_api.g_varchar2)
2942: )
2943: OR (
2944: l_source_pension_scheme IS NOT NULL
2945: AND l_pension_scheme = 'ANY'
2953: p_employment_type = l_employment_type
2954: OR ( --115.70 5897563
2955: --ANY refers only to REGULAR and CASUAL employment types
2956: -- p_employment_type IS NOT NULL
2957: nvl( p_employment_type,hr_api.g_varchar2) in
2958: ('REGULAR','CASUAL')
2959: AND l_employment_type = 'ANY'
2960: )
2961: )
3569: -- Regular/fixed term employees can opt into partnership schemes as well
3570: -- IF g_tab_pen_sch_map_cv(i).pcv_information1 <> 'PARTNER'
3571: -- THEN
3572: IF l_rec_ele_ent_details.effective_end_date <>
3573: hr_api.g_eot
3574: AND -- Bug 4873436: chk opt out only as of or b4 cutover date
3575: l_rec_ele_ent_details.effective_end_date <=
3576: g_effective_date
3577: AND g_opt_out = 'Y'
3689: -- Check whether person is a member of partnership scheme
3690: IF g_tab_pen_sch_map_cv(i).pcv_information2 = 'PARTNER'
3691: THEN
3692: IF l_rec_ele_ent_details.effective_end_date <>
3693: hr_api.g_eot
3694: AND -- Bug 4873436: chk opt out only as of or b4 cutover date
3695: l_rec_ele_ent_details.effective_end_date <=
3696: g_effective_date
3697: AND g_opt_out = 'Y'
4147: OPEN csr_get_asg_details(l_ser_start_date);
4148: FETCH csr_get_asg_details INTO l_effective_date;
4149: FETCH csr_get_asg_details INTO l_next_effective_date;
4150:
4151: IF l_effective_date <> hr_api.g_eot
4152: AND csr_get_asg_details%NOTFOUND
4153: THEN
4154: -- This is due to termination event
4155: l_start_reason := 'ZZ';
4184:
4185: g_ser_start_date := l_ser_start_date;
4186:
4187: IF l_start_reason = 'ZZ'
4188: AND NVL(l_asg_status_type_id, hr_api.g_number) <>
4189: g_terminate_asg_sts_id
4190: THEN
4191: l_asg_status_type_id := g_terminate_asg_sts_id;
4192: END IF;
5131: AND paaf.assignment_status_type_id = past.assignment_status_type_id
5132: and pps.person_id = paaf.person_id
5133: and pps.period_of_service_id = paaf.period_of_service_id
5134: AND past.per_system_status = 'ACTIVE_ASSIGN'
5135: and g_effective_date <> NVL(pps.final_process_date, hr_api.g_eot)
5136: AND g_effective_date BETWEEN paaf.effective_start_date
5137: AND paaf.effective_end_date
5138: ORDER BY paaf.effective_start_date;
5139:
5525: END IF;
5526:
5527: IF g_tab_pen_ele_ids.EXISTS(l_rec_ele_ent_info.element_type_id)
5528: AND g_opt_out = 'Y'
5529: AND l_rec_ele_ent_info.effective_end_date <> hr_api.g_eot
5530: AND l_rec_ele_ent_info.effective_end_date <=
5531: pqp_gb_psi_functions.g_effective_end_date
5532: THEN
5533: -- Yes this is an end date event
5540: OPEN csr_get_asg_details;
5541: FETCH csr_get_asg_details INTO l_effective_end_date;
5542: -- FETCH csr_get_asg_details INTO l_next_effective_end_date;
5543:
5544: IF l_effective_end_date = hr_api.g_eot
5545: OR csr_get_asg_details%FOUND
5546: THEN
5547: -- This is NOT due to a leaver event
5548: -- might be an opt out event
6718: END IF; -- End if of leaving reason is not null check ...
6719: END IF; -- End if of l_start_reason = 'ZZ' check ...
6720:
6721: IF l_start_reason = 'ZZ'
6722: AND NVL(l_asg_status_type_id, hr_api.g_number) <>
6723: g_terminate_asg_sts_id
6724: THEN
6725: l_asg_status_type_id := g_terminate_asg_sts_id;
6726: END IF;
6971: ,p_assignment_dtl => g_assignment_dtl
6972: );
6973:
6974: -- Initialize counter only for a different person (tested for rehires)
6975: IF NVL(g_person_id, hr_api.g_number) <> g_assignment_dtl.person_id
6976: THEN
6977: clear_per_cache;
6978: g_person_id := g_assignment_dtl.person_id;
6979: -- ELSE