DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_BRGNG_UNIT_PRTE_F

Line 135: from BEN_ELIG_BRGNG_UNIT_PRTE_F

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:

Line 2403: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);

2399: ,P_OBJECT_VERSION_NUMBER => l_ovn
2400: );
2401: end if;
2402: if l_bu_flag = 'Y' then
2403: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);
2404: hr_utility.set_location('bargaining unit cd is'||r_elp.information101,20);
2405: BEN_ELIG_BRGNG_UNIT_PRTE_API.CREATE_ELIG_BRGNG_UNIT_PRTE(
2406: P_EFFECTIVE_DATE => l_effective_date
2407: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2610: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);

2606: p_crit_type => 'RL',
2607: p_effective_date => l_effective_date);
2608: end if;
2609: if l_bu_flag = 'Y' and l_old_bu_flag is null and r_elp.information228 is null then
2610: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);
2611: BEN_ELIG_BRGNG_UNIT_PRTE_API.CREATE_ELIG_BRGNG_UNIT_PRTE(
2612: P_EFFECTIVE_DATE => l_effective_date
2613: ,P_BUSINESS_GROUP_ID => p_business_group_id
2614: ,P_BRGNG_UNIT_CD => r_elp.information101