APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_OTHR_PTIP_PRTE_F

Line 12912: -- and tr.where_clause = l_BEN_ELIG_OTHR_PTIP_PRTE_F

12908: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12909: pqh_table_route tr
12910: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12911: and cpe.table_route_id = tr.table_route_id
12912: -- and tr.where_clause = l_BEN_ELIG_OTHR_PTIP_PRTE_F
12913: and tr.table_alias = l_table_alias
12914: and cpe.number_of_copies = 1 -- ADDITION
12915: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12916: order by information1, information2; --added for bug: 5151945

Line 12950: from BEN_ELIG_OTHR_PTIP_PRTE_F EOY

12946: c_business_group_id number,
12947: c_new_pk_id number) is
12948: select
12949: EOY.elig_othr_ptip_prte_id new_value
12950: from BEN_ELIG_OTHR_PTIP_PRTE_F EOY
12951: where
12952: EOY.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12953: EOY.PTIP_ID = l_PTIP_ID and
12954: EOY.business_group_id = c_business_group_id

Line 12961: from BEN_ELIG_OTHR_PTIP_PRTE_F EOY1

12957: and effective_end_date ;
12958: --END TEMPIK
12959: /*TEMPIK
12960: and exists ( select null
12961: from BEN_ELIG_OTHR_PTIP_PRTE_F EOY1
12962: where
12963: EOY1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12964: EOY1.PTIP_ID = l_PTIP_ID and
12965: EOY1.business_group_id = c_business_group_id

Line 12968: from BEN_ELIG_OTHR_PTIP_PRTE_F EOY2

12964: EOY1.PTIP_ID = l_PTIP_ID and
12965: EOY1.business_group_id = c_business_group_id
12966: and EOY1.effective_start_date <= c_effective_start_date )
12967: and exists ( select null
12968: from BEN_ELIG_OTHR_PTIP_PRTE_F EOY2
12969: where
12970: EOY2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
12971: EOY2.PTIP_ID = l_PTIP_ID and
12972: EOY2.business_group_id = c_business_group_id

Line 13128: (p_base_table_name => 'BEN_ELIG_OTHR_PTIP_PRTE_F',

13124: if c_find_EOY_in_target%found then
13125: --
13126: --TEMPIK
13127: l_dt_rec_found := dt_api.check_min_max_dates
13128: (p_base_table_name => 'BEN_ELIG_OTHR_PTIP_PRTE_F',
13129: p_base_key_column => 'ELIG_OTHR_PTIP_PRTE_ID',
13130: p_base_key_value => l_new_value,
13131: p_from_date => l_min_esd,
13132: p_to_date => l_max_eed );

Line 13188: hr_utility.set_location(' BEN_ELIG_OTHR_PTIP_PRTE_F CREATE_ELIG_OTHR_PTIP_PRTE ',20);

13184: end if;
13185:
13186: if l_first_rec and not l_update then
13187: -- Call Create routine.
13188: hr_utility.set_location(' BEN_ELIG_OTHR_PTIP_PRTE_F CREATE_ELIG_OTHR_PTIP_PRTE ',20);
13189: BEN_ELIG_OTHR_PTIP_PRTE_API.CREATE_ELIG_OTHR_PTIP_PRTE(
13190: --
13191: P_VALIDATE => false
13192: ,P_EFFECTIVE_DATE => l_effective_date

Line 13260: hr_utility.set_location(' BEN_ELIG_OTHR_PTIP_PRTE_F UPDATE_ELIG_OTHR_PTIP_PRTE ',30);

13256: else
13257: --
13258: -- Call Update routine for the pk_id created in prev run .
13259: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
13260: hr_utility.set_location(' BEN_ELIG_OTHR_PTIP_PRTE_F UPDATE_ELIG_OTHR_PTIP_PRTE ',30);
13261: --UPD START
13262: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
13263: --
13264: if l_update then