DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 183: from BEN_ELIG_ORG_UNIT_PRTE_F

179: );
180: elsif p_crit_type ='ORG' then
181: select elig_org_unit_prte_id,object_version_number
182: into l_pk,l_ovn
183: from BEN_ELIG_ORG_UNIT_PRTE_F
184: where eligy_prfl_id = p_elig_prfl_id
185: and p_effective_date between effective_start_date and effective_end_date;
186: hr_utility.set_location('pk selected is'||l_pk,100);
187:

Line 2504: hr_utility.set_location(' BEN_ELIG_ORG_UNIT_PRTE_F CREATE_ELIG_ORG_UNIT_PRTE ',20);

2500: ,P_OBJECT_VERSION_NUMBER => l_ovn
2501: );
2502: end if;
2503: if l_org_flag = 'Y' then
2504: hr_utility.set_location(' BEN_ELIG_ORG_UNIT_PRTE_F CREATE_ELIG_ORG_UNIT_PRTE ',20);
2505: hr_utility.set_location('org id is'||r_elp.information234,20);
2506: BEN_ELIG_ORG_UNIT_PRTE_API.CREATE_ELIG_ORG_UNIT_PRTE(
2507: P_EFFECTIVE_DATE => l_effective_date
2508: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2727: hr_utility.set_location(' BEN_ELIG_ORG_UNIT_PRTE_F CREATE_ELIG_ORG_UNIT_PRTE ',20);

2723: p_crit_type => 'LOC',
2724: p_effective_date => l_effective_date);
2725: end if;
2726: if l_org_flag = 'Y' and l_old_org_flag is null and r_elp.information224 is null then
2727: hr_utility.set_location(' BEN_ELIG_ORG_UNIT_PRTE_F CREATE_ELIG_ORG_UNIT_PRTE ',20);
2728: BEN_ELIG_ORG_UNIT_PRTE_API.CREATE_ELIG_ORG_UNIT_PRTE(
2729: P_EFFECTIVE_DATE => l_effective_date
2730: ,P_BUSINESS_GROUP_ID => p_business_group_id
2731: ,P_ELIGY_PRFL_ID => l_elp_id