APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_PSTN_PRTE_F

Line 16449: -- and tr.where_clause = l_BEN_ELIG_PSTN_PRTE_F

16445: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16446: pqh_table_route tr
16447: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16448: and cpe.table_route_id = tr.table_route_id
16449: -- and tr.where_clause = l_BEN_ELIG_PSTN_PRTE_F
16450: and tr.table_alias = l_table_alias
16451: and cpe.number_of_copies = 1 -- ADDITION
16452: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
16453: order by information1, information2; --added for bug: 5151945

Line 16487: from BEN_ELIG_PSTN_PRTE_F EPS

16483: c_business_group_id number,
16484: c_new_pk_id number) is
16485: select
16486: EPS.elig_pstn_prte_id new_value
16487: from BEN_ELIG_PSTN_PRTE_F EPS
16488: where
16489: EPS.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
16490: EPS.POSITION_ID = l_POSITION_ID and
16491: EPS.business_group_id = c_business_group_id

Line 16498: from BEN_ELIG_PSTN_PRTE_F EPS1

16494: and effective_end_date ;
16495: --END TEMPIK
16496: /*TEMPIK
16497: and exists ( select null
16498: from BEN_ELIG_PSTN_PRTE_F EPS1
16499: where
16500: EPS1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
16501: EPS1.POSITION_ID = l_POSITION_ID and
16502: EPS1.business_group_id = c_business_group_id

Line 16505: from BEN_ELIG_PSTN_PRTE_F EPS2

16501: EPS1.POSITION_ID = l_POSITION_ID and
16502: EPS1.business_group_id = c_business_group_id
16503: and EPS1.effective_start_date <= c_effective_start_date )
16504: and exists ( select null
16505: from BEN_ELIG_PSTN_PRTE_F EPS2
16506: where
16507: EPS2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
16508: EPS2.POSITION_ID = l_POSITION_ID and
16509: EPS2.business_group_id = c_business_group_id

Line 16681: (p_base_table_name => 'BEN_ELIG_PSTN_PRTE_F',

16677: if c_find_EPS_in_target%found then
16678: --
16679: --TEMPIK
16680: l_dt_rec_found := dt_api.check_min_max_dates
16681: (p_base_table_name => 'BEN_ELIG_PSTN_PRTE_F',
16682: p_base_key_column => 'ELIG_PSTN_PRTE_ID',
16683: p_base_key_value => l_new_value,
16684: p_from_date => l_min_esd,
16685: p_to_date => l_max_eed );

Line 16744: hr_utility.set_location(' BEN_ELIG_PSTN_PRTE_F CREATE_ELIG_PSTN_PRTE ',20);

16740: end if;
16741:
16742: if l_first_rec and not l_update then
16743: -- Call Create routine.
16744: hr_utility.set_location(' BEN_ELIG_PSTN_PRTE_F CREATE_ELIG_PSTN_PRTE ',20);
16745: BEN_ELIG_PSTN_PRTE_API.CREATE_ELIG_PSTN_PRTE(
16746: --
16747: P_VALIDATE => false
16748: ,P_EFFECTIVE_DATE => l_effective_date

Line 16817: hr_utility.set_location(' BEN_ELIG_PSTN_PRTE_F UPDATE_ELIG_PSTN_PRTE ',30);

16813: else
16814: --
16815: -- Call Update routine for the pk_id created in prev run .
16816: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
16817: hr_utility.set_location(' BEN_ELIG_PSTN_PRTE_F UPDATE_ELIG_PSTN_PRTE ',30);
16818: --UPD START
16819: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
16820: --
16821: if l_update then