APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_HRLY_SLRD_PRTE_F

Line 27165: -- and tr.where_clause = l_BEN_ELIG_HRLY_SLRD_PRTE_F

27161: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
27162: pqh_table_route tr
27163: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27164: and cpe.table_route_id = tr.table_route_id
27165: -- and tr.where_clause = l_BEN_ELIG_HRLY_SLRD_PRTE_F
27166: and tr.table_alias = l_table_alias
27167: and cpe.number_of_copies = 1 -- ADDITION
27168: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
27169: order by information1, information2; --added for bug: 5151945

Line 27203: from BEN_ELIG_HRLY_SLRD_PRTE_F EHS

27199: c_business_group_id number,
27200: c_new_pk_id number) is
27201: select
27202: EHS.elig_hrly_slrd_prte_id new_value
27203: from BEN_ELIG_HRLY_SLRD_PRTE_F EHS
27204: where
27205: EHS.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
27206: EHS.business_group_id = c_business_group_id
27207: and EHS.elig_hrly_slrd_prte_id <> c_new_pk_id

Line 27213: from BEN_ELIG_HRLY_SLRD_PRTE_F EHS1

27209: and effective_end_date ;
27210: --END TEMPIK
27211: /*TEMPIK
27212: and exists ( select null
27213: from BEN_ELIG_HRLY_SLRD_PRTE_F EHS1
27214: where
27215: EHS1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
27216:
27217: -- Additional Filter Condition

Line 27223: from BEN_ELIG_HRLY_SLRD_PRTE_F EHS2

27219:
27220: EHS1.business_group_id = c_business_group_id
27221: and EHS1.effective_start_date <= c_effective_start_date )
27222: and exists ( select null
27223: from BEN_ELIG_HRLY_SLRD_PRTE_F EHS2
27224: where
27225: EHS2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
27226:
27227: -- Additional Filter Condition

Line 27385: (p_base_table_name => 'BEN_ELIG_HRLY_SLRD_PRTE_F',

27381: if c_find_EHS_in_target%found then
27382: --
27383: --TEMPIK
27384: l_dt_rec_found := dt_api.check_min_max_dates
27385: (p_base_table_name => 'BEN_ELIG_HRLY_SLRD_PRTE_F',
27386: p_base_key_column => 'ELIG_HRLY_SLRD_PRTE_ID',
27387: p_base_key_value => l_new_value,
27388: p_from_date => l_min_esd,
27389: p_to_date => l_max_eed );

Line 27445: hr_utility.set_location(' BEN_ELIG_HRLY_SLRD_PRTE_F CREATE_ELIG_HRLY_SLRD_PRTE ',20);

27441: end if;
27442:
27443: if l_first_rec and not l_update then
27444: -- Call Create routine.
27445: hr_utility.set_location(' BEN_ELIG_HRLY_SLRD_PRTE_F CREATE_ELIG_HRLY_SLRD_PRTE ',20);
27446: BEN_ELIG_HRLY_SLRD_PRTE_API.CREATE_ELIG_HRLY_SLRD_PRTE(
27447: --
27448: P_VALIDATE => false
27449: ,P_EFFECTIVE_DATE => l_effective_date

Line 27518: hr_utility.set_location(' BEN_ELIG_HRLY_SLRD_PRTE_F UPDATE_ELIG_HRLY_SLRD_PRTE ',30);

27514: else
27515: --
27516: -- Call Update routine for the pk_id created in prev run .
27517: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
27518: hr_utility.set_location(' BEN_ELIG_HRLY_SLRD_PRTE_F UPDATE_ELIG_HRLY_SLRD_PRTE ',30);
27519: --UPD START
27520: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
27521: --
27522: if l_update then