APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PRTN_ELIG_PRFL_F

Line 12534: -- and tr.where_clause = l_BEN_PRTN_ELIG_PRFL_F

12530: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12531: pqh_table_route tr
12532: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12533: and cpe.table_route_id = tr.table_route_id
12534: -- and tr.where_clause = l_BEN_PRTN_ELIG_PRFL_F
12535: and tr.table_alias = l_table_alias
12536: and cpe.number_of_copies = 1 -- ADDITION
12537: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12538: order by information1, information2; --added for bug: 5151945

Line 12572: from BEN_PRTN_ELIG_PRFL_F CEP

12568: c_business_group_id number,
12569: c_new_pk_id number) is
12570: select
12571: CEP.prtn_elig_prfl_id new_value
12572: from BEN_PRTN_ELIG_PRFL_F CEP
12573: where
12574: CEP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12575: CEP.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12576: CEP.business_group_id = c_business_group_id

Line 12584: from BEN_PRTN_ELIG_PRFL_F CEP1

12580: and effective_end_date ;
12581: --END TEMPIK
12582: /*TEMPIK
12583: and exists ( select null
12584: from BEN_PRTN_ELIG_PRFL_F CEP1
12585: where
12586: CEP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12587: CEP1.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12588: CEP1.business_group_id = c_business_group_id

Line 12591: from BEN_PRTN_ELIG_PRFL_F CEP2

12587: CEP1.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12588: CEP1.business_group_id = c_business_group_id
12589: and CEP1.effective_start_date <= c_effective_start_date )
12590: and exists ( select null
12591: from BEN_PRTN_ELIG_PRFL_F CEP2
12592: where
12593: CEP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12594: CEP2.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12595: CEP2.business_group_id = c_business_group_id

Line 12737: (p_base_table_name => 'BEN_PRTN_ELIG_PRFL_F',

12733: if c_find_CEP_in_target%found then
12734: --
12735: --TEMPIK
12736: l_dt_rec_found := dt_api.check_min_max_dates
12737: (p_base_table_name => 'BEN_PRTN_ELIG_PRFL_F',
12738: p_base_key_column => 'PRTN_ELIG_PRFL_ID',
12739: p_base_key_value => l_new_value,
12740: p_from_date => l_min_esd,
12741: p_to_date => l_max_eed );

Line 12796: hr_utility.set_location(' BEN_PRTN_ELIG_PRFL_F CREATE_PRTN_ELIG_PRFL ',20);

12792: end if;
12793:
12794: if l_first_rec and not l_update then
12795: -- Call Create routine.
12796: hr_utility.set_location(' BEN_PRTN_ELIG_PRFL_F CREATE_PRTN_ELIG_PRFL ',20);
12797: BEN_PRTN_ELIG_PRFL_API.CREATE_PRTN_ELIG_PRFL(
12798: --
12799: P_VALIDATE => false
12800: ,P_EFFECTIVE_DATE => l_effective_date

Line 12864: hr_utility.set_location(' BEN_PRTN_ELIG_PRFL_F UPDATE_PRTN_ELIG_PRFL ',30);

12860: else
12861: --
12862: -- Call Update routine for the pk_id created in prev run .
12863: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
12864: hr_utility.set_location(' BEN_PRTN_ELIG_PRFL_F UPDATE_PRTN_ELIG_PRFL ',30);
12865: --UPD START
12866: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
12867: --
12868: if l_update then