APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_ENRLD_ANTHR_PLIP_F

Line 24649: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PLIP_F

24645: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24646: pqh_table_route tr
24647: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24648: and cpe.table_route_id = tr.table_route_id
24649: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PLIP_F
24650: and tr.table_alias = l_table_alias
24651: and cpe.number_of_copies = 1 -- ADDITION
24652: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
24653: order by information1, information2; --added for bug: 5151945

Line 24687: from BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI

24683: c_business_group_id number,
24684: c_new_pk_id number) is
24685: select
24686: EAI.elig_enrld_anthr_plip_id new_value
24687: from BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI
24688: where
24689: EAI.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
24690: EAI.PLIP_ID = l_PLIP_ID and
24691: EAI.business_group_id = c_business_group_id

Line 24698: from BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI1

24694: and effective_end_date ;
24695: --END TEMPIK
24696: /*TEMPIK
24697: and exists ( select null
24698: from BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI1
24699: where
24700: EAI1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
24701: EAI1.PLIP_ID = l_PLIP_ID and
24702: EAI1.business_group_id = c_business_group_id

Line 24705: from BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI2

24701: EAI1.PLIP_ID = l_PLIP_ID and
24702: EAI1.business_group_id = c_business_group_id
24703: and EAI1.effective_start_date <= c_effective_start_date )
24704: and exists ( select null
24705: from BEN_ELIG_ENRLD_ANTHR_PLIP_F EAI2
24706: where
24707: EAI2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
24708: EAI2.PLIP_ID = l_PLIP_ID and
24709: EAI2.business_group_id = c_business_group_id

Line 24865: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PLIP_F',

24861: if c_find_EAI_in_target%found then
24862: --
24863: --TEMPIK
24864: l_dt_rec_found := dt_api.check_min_max_dates
24865: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PLIP_F',
24866: p_base_key_column => 'ELIG_ENRLD_ANTHR_PLIP_ID',
24867: p_base_key_value => l_new_value,
24868: p_from_date => l_min_esd,
24869: p_to_date => l_max_eed );

Line 24925: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PLIP_F CREATE_ELIG_ENRLD_ANTHR_PLIP ',20);

24921: end if;
24922:
24923: if l_first_rec and not l_update then
24924: -- Call Create routine.
24925: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PLIP_F CREATE_ELIG_ENRLD_ANTHR_PLIP ',20);
24926: BEN_ELIG_ENRLD_ANTHR_PLIP_API.CREATE_ELIG_ENRLD_ANTHR_PLIP(
24927: --
24928: P_VALIDATE => false
24929: ,P_EFFECTIVE_DATE => l_effective_date

Line 24997: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PLIP_F UPDATE_ELIG_ENRLD_ANTHR_PLIP ',30);

24993: else
24994: --
24995: -- Call Update routine for the pk_id created in prev run .
24996: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
24997: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PLIP_F UPDATE_ELIG_ENRLD_ANTHR_PLIP ',30);
24998: --UPD START
24999: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
25000: --
25001: if l_update then