APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 12392: -- and tr.where_clause = l_BEN_ELIG_ORG_UNIT_PRTE_F

12388: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12389: pqh_table_route tr
12390: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12391: and cpe.table_route_id = tr.table_route_id
12392: -- and tr.where_clause = l_BEN_ELIG_ORG_UNIT_PRTE_F
12393: and tr.table_alias = l_table_alias
12394: and cpe.number_of_copies = 1 -- ADDITION
12395: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12396: order by information1, information2; --added for bug: 5151945

Line 12430: from BEN_ELIG_ORG_UNIT_PRTE_F EOU

12426: c_business_group_id number,
12427: c_new_pk_id number) is
12428: select
12429: EOU.elig_org_unit_prte_id new_value
12430: from BEN_ELIG_ORG_UNIT_PRTE_F EOU
12431: where
12432: EOU.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12433: EOU.ORGANIZATION_ID = l_ORGANIZATION_ID and
12434: EOU.business_group_id = c_business_group_id

Line 12441: from BEN_ELIG_ORG_UNIT_PRTE_F EOU1

12437: and effective_end_date ;
12438: --END TEMPIK
12439: /*TEMPIK
12440: and exists ( select null
12441: from BEN_ELIG_ORG_UNIT_PRTE_F EOU1
12442: where
12443: EOU1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12444: EOU1.ORGANIZATION_ID = l_ORGANIZATION_ID and
12445: EOU1.business_group_id = c_business_group_id

Line 12448: from BEN_ELIG_ORG_UNIT_PRTE_F EOU2

12444: EOU1.ORGANIZATION_ID = l_ORGANIZATION_ID and
12445: EOU1.business_group_id = c_business_group_id
12446: and EOU1.effective_start_date <= c_effective_start_date )
12447: and exists ( select null
12448: from BEN_ELIG_ORG_UNIT_PRTE_F EOU2
12449: where
12450: EOU2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12451: EOU2.ORGANIZATION_ID = l_ORGANIZATION_ID and
12452: EOU2.business_group_id = c_business_group_id

Line 12624: (p_base_table_name => 'BEN_ELIG_ORG_UNIT_PRTE_F',

12620: if c_find_EOU_in_target%found then
12621: --
12622: --TEMPIK
12623: l_dt_rec_found := dt_api.check_min_max_dates
12624: (p_base_table_name => 'BEN_ELIG_ORG_UNIT_PRTE_F',
12625: p_base_key_column => 'ELIG_ORG_UNIT_PRTE_ID',
12626: p_base_key_value => l_new_value,
12627: p_from_date => l_min_esd,
12628: p_to_date => l_max_eed );

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

12684: end if;
12685:
12686: if l_first_rec and not l_update then
12687: -- Call Create routine.
12688: hr_utility.set_location(' BEN_ELIG_ORG_UNIT_PRTE_F CREATE_ELIG_ORG_UNIT_PRTE ',20);
12689: BEN_ELIG_ORG_UNIT_PRTE_API.CREATE_ELIG_ORG_UNIT_PRTE(
12690: --
12691: P_VALIDATE => false
12692: ,P_EFFECTIVE_DATE => l_effective_date

Line 12761: hr_utility.set_location(' BEN_ELIG_ORG_UNIT_PRTE_F UPDATE_ELIG_ORG_UNIT_PRTE ',30);

12757: else
12758: --
12759: -- Call Update routine for the pk_id created in prev run .
12760: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
12761: hr_utility.set_location(' BEN_ELIG_ORG_UNIT_PRTE_F UPDATE_ELIG_ORG_UNIT_PRTE ',30);
12762: --UPD START
12763: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
12764: --
12765: if l_update then