[Home] [Help]
131: );
132: elsif p_crit_type ='BU' then
133: select elig_brgng_unit_prte_id,object_version_number
134: into l_pk,l_ovn
135: from BEN_ELIG_BRGNG_UNIT_PRTE_F
136: where eligy_prfl_id = p_elig_prfl_id
137: and p_effective_date between effective_start_date and effective_end_date;
138: hr_utility.set_location('pk selected is'||l_pk,100);
139:
2400: ,P_OBJECT_VERSION_NUMBER => l_ovn
2401: );
2402: end if;
2403: if l_bu_flag = 'Y' then
2404: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);
2405: hr_utility.set_location('bargaining unit cd is'||r_elp.information101,20);
2406: BEN_ELIG_BRGNG_UNIT_PRTE_API.CREATE_ELIG_BRGNG_UNIT_PRTE(
2407: P_EFFECTIVE_DATE => l_effective_date
2408: ,P_BUSINESS_GROUP_ID => p_business_group_id
2607: p_crit_type => 'RL',
2608: p_effective_date => l_effective_date);
2609: end if;
2610: if l_bu_flag = 'Y' and l_old_bu_flag is null and r_elp.information228 is null then
2611: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);
2612: BEN_ELIG_BRGNG_UNIT_PRTE_API.CREATE_ELIG_BRGNG_UNIT_PRTE(
2613: P_EFFECTIVE_DATE => l_effective_date
2614: ,P_BUSINESS_GROUP_ID => p_business_group_id
2615: ,P_BRGNG_UNIT_CD => r_elp.information101