APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_EE_STAT_PRTE_F

Line 23147: -- and tr.where_clause = l_BEN_ELIG_EE_STAT_PRTE_F

23143: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23144: pqh_table_route tr
23145: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23146: and cpe.table_route_id = tr.table_route_id
23147: -- and tr.where_clause = l_BEN_ELIG_EE_STAT_PRTE_F
23148: and tr.table_alias = l_table_alias
23149: and cpe.number_of_copies = 1 -- ADDITION
23150: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
23151: order by information1, information2; --added for bug: 5151945

Line 23185: from BEN_ELIG_EE_STAT_PRTE_F EES

23181: c_business_group_id number,
23182: c_new_pk_id number) is
23183: select
23184: EES.elig_ee_stat_prte_id new_value
23185: from BEN_ELIG_EE_STAT_PRTE_F EES
23186: where
23187: EES.ASSIGNMENT_STATUS_TYPE_ID = l_ASSIGNMENT_STATUS_TYPE_ID and
23188: EES.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
23189: EES.business_group_id = c_business_group_id

Line 23196: from BEN_ELIG_EE_STAT_PRTE_F EES1

23192: and effective_end_date ;
23193: --END TEMPIK
23194: /*TEMPIK
23195: and exists ( select null
23196: from BEN_ELIG_EE_STAT_PRTE_F EES1
23197: where
23198: EES1.ASSIGNMENT_STATUS_TYPE_ID = l_ASSIGNMENT_STATUS_TYPE_ID and
23199: EES1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
23200: EES1.business_group_id = c_business_group_id

Line 23203: from BEN_ELIG_EE_STAT_PRTE_F EES2

23199: EES1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
23200: EES1.business_group_id = c_business_group_id
23201: and EES1.effective_start_date <= c_effective_start_date )
23202: and exists ( select null
23203: from BEN_ELIG_EE_STAT_PRTE_F EES2
23204: where
23205: EES2.ASSIGNMENT_STATUS_TYPE_ID = l_ASSIGNMENT_STATUS_TYPE_ID and
23206: EES2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
23207: EES2.business_group_id = c_business_group_id

Line 23377: (p_base_table_name => 'BEN_ELIG_EE_STAT_PRTE_F',

23373: if c_find_EES_in_target%found then
23374: --
23375: --TEMPIK
23376: l_dt_rec_found := dt_api.check_min_max_dates
23377: (p_base_table_name => 'BEN_ELIG_EE_STAT_PRTE_F',
23378: p_base_key_column => 'ELIG_EE_STAT_PRTE_ID',
23379: p_base_key_value => l_new_value,
23380: p_from_date => l_min_esd,
23381: p_to_date => l_max_eed );

Line 23440: hr_utility.set_location(' BEN_ELIG_EE_STAT_PRTE_F CREATE_ELIG_EE_STAT_PRTE ',20);

23436: end if;
23437:
23438: if l_first_rec and not l_update then
23439: -- Call Create routine.
23440: hr_utility.set_location(' BEN_ELIG_EE_STAT_PRTE_F CREATE_ELIG_EE_STAT_PRTE ',20);
23441: BEN_ELIG_EE_STAT_PRTE_API.CREATE_ELIG_EE_STAT_PRTE(
23442: --
23443: P_VALIDATE => false
23444: ,P_EFFECTIVE_DATE => l_effective_date

Line 23513: hr_utility.set_location(' BEN_ELIG_EE_STAT_PRTE_F UPDATE_ELIG_EE_STAT_PRTE ',30);

23509: else
23510: --
23511: -- Call Update routine for the pk_id created in prev run .
23512: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
23513: hr_utility.set_location(' BEN_ELIG_EE_STAT_PRTE_F UPDATE_ELIG_EE_STAT_PRTE ',30);
23514: --UPD START
23515: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
23516: --
23517: if l_update then