APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_OTHR_PTIP_RT_F

Line 12544: -- and tr.where_clause = l_BEN_OTHR_PTIP_RT_F

12540: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12541: pqh_table_route tr
12542: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12543: and cpe.table_route_id = tr.table_route_id
12544: -- and tr.where_clause = l_BEN_OTHR_PTIP_RT_F
12545: and tr.table_alias = l_table_alias
12546: and cpe.number_of_copies = 1 -- ADDITION
12547: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12548: order by information1, information2; --added for bug: 5151945

Line 12582: from BEN_OTHR_PTIP_RT_F OPR

12578: c_business_group_id number,
12579: c_new_pk_id number) is
12580: select
12581: OPR.othr_ptip_rt_id new_value
12582: from BEN_OTHR_PTIP_RT_F OPR
12583: where
12584: OPR.PTIP_ID = l_PTIP_ID and
12585: OPR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12586: OPR.business_group_id = c_business_group_id

Line 12594: from BEN_OTHR_PTIP_RT_F OPR1

12590: and effective_end_date ;
12591: --END TEMPIK
12592: /*TEMPIK
12593: and exists ( select null
12594: from BEN_OTHR_PTIP_RT_F OPR1
12595: where
12596: OPR1.PTIP_ID = l_PTIP_ID and
12597: OPR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12598: OPR1.business_group_id = c_business_group_id

Line 12601: from BEN_OTHR_PTIP_RT_F OPR2

12597: OPR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12598: OPR1.business_group_id = c_business_group_id
12599: and OPR1.effective_start_date <= c_effective_start_date )
12600: and exists ( select null
12601: from BEN_OTHR_PTIP_RT_F OPR2
12602: where
12603: OPR2.PTIP_ID = l_PTIP_ID and
12604: OPR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
12605: OPR2.business_group_id = c_business_group_id

Line 12740: (p_base_table_name => 'BEN_OTHR_PTIP_RT_F',

12736: if c_find_OPR_in_target%found then
12737: --
12738: --TEMPIK
12739: l_dt_rec_found := dt_api.check_min_max_dates
12740: (p_base_table_name => 'BEN_OTHR_PTIP_RT_F',
12741: p_base_key_column => 'OTHR_PTIP_RT_ID',
12742: p_base_key_value => l_new_value,
12743: p_from_date => l_min_esd,
12744: p_to_date => l_max_eed );

Line 12798: hr_utility.set_location(' BEN_OTHR_PTIP_RT_F CREATE_OTHR_PTIP_RT ',20);

12794: end if;
12795:
12796: if l_first_rec and not l_update then
12797: -- Call Create routine.
12798: hr_utility.set_location(' BEN_OTHR_PTIP_RT_F CREATE_OTHR_PTIP_RT ',20);
12799: BEN_OTHR_PTIP_RT_API.CREATE_OTHR_PTIP_RT(
12800: --
12801: P_VALIDATE => false
12802: ,P_EFFECTIVE_DATE => l_effective_date

Line 12891: hr_utility.set_location(' BEN_OTHR_PTIP_RT_F UPDATE_OTHR_PTIP_RT ',30);

12887: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
12888: --
12889: IF l_update OR l_dml_operation <> 'UPDATE' THEN
12890: --UPD END
12891: hr_utility.set_location(' BEN_OTHR_PTIP_RT_F UPDATE_OTHR_PTIP_RT ',30);
12892: BEN_OTHR_PTIP_RT_API.UPDATE_OTHR_PTIP_RT(
12893: --
12894: P_VALIDATE => false
12895: ,P_EFFECTIVE_DATE => l_effective_date