APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_LVG_RSN_RT_F

Line 23754: -- and tr.where_clause = l_BEN_LVG_RSN_RT_F

23750: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23751: pqh_table_route tr
23752: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23753: and cpe.table_route_id = tr.table_route_id
23754: -- and tr.where_clause = l_BEN_LVG_RSN_RT_F
23755: and tr.table_alias = l_table_alias
23756: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
23757: order by information1, information2; --added for bug: 5151945
23758: --

Line 23791: from BEN_LVG_RSN_RT_F LRN

23787: c_business_group_id number,
23788: c_new_pk_id number) is
23789: select
23790: LRN.lvg_rsn_rt_id new_value
23791: from BEN_LVG_RSN_RT_F LRN
23792: where
23793: LRN.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
23794: LRN.LVG_RSN_CD = l_LVG_RSN_CD and
23795: LRN.business_group_id = c_business_group_id

Line 23803: from BEN_LVG_RSN_RT_F LRN1

23799: and effective_end_date ;
23800: --END TEMPIK
23801: /*TEMPIK
23802: and exists ( select null
23803: from BEN_LVG_RSN_RT_F LRN1
23804: where
23805: LRN1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
23806: LRN1.LVG_RSN_CD = l_LVG_RSN_CD and
23807: LRN1.business_group_id = c_business_group_id

Line 23810: from BEN_LVG_RSN_RT_F LRN2

23806: LRN1.LVG_RSN_CD = l_LVG_RSN_CD and
23807: LRN1.business_group_id = c_business_group_id
23808: and LRN1.effective_start_date <= c_effective_start_date )
23809: and exists ( select null
23810: from BEN_LVG_RSN_RT_F LRN2
23811: where
23812: LRN2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
23813: LRN2.LVG_RSN_CD = l_LVG_RSN_CD and
23814: LRN2.business_group_id = c_business_group_id

Line 23946: (p_base_table_name => 'BEN_LVG_RSN_RT_F',

23942: if c_find_LRN_in_target%found then
23943: --
23944: --TEMPIK
23945: l_dt_rec_found := dt_api.check_min_max_dates
23946: (p_base_table_name => 'BEN_LVG_RSN_RT_F',
23947: p_base_key_column => 'LVG_RSN_RT_ID',
23948: p_base_key_value => l_new_value,
23949: p_from_date => l_min_esd,
23950: p_to_date => l_max_eed );

Line 24004: hr_utility.set_location(' BEN_LVG_RSN_RT_F CREATE_LVG_RSN_RT ',20);

24000: end if;
24001:
24002: if l_first_rec and not l_update then
24003: -- Call Create routine.
24004: hr_utility.set_location(' BEN_LVG_RSN_RT_F CREATE_LVG_RSN_RT ',20);
24005: BEN_LVG_RSN_RT_API.CREATE_LVG_RSN_RT(
24006: --
24007: P_VALIDATE => false
24008: ,P_EFFECTIVE_DATE => l_effective_date

Line 24096: hr_utility.set_location(' BEN_LVG_RSN_RT_F UPDATE_LVG_RSN_RT ',30);

24092: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
24093: --
24094: IF l_update OR l_dml_operation <> 'UPDATE' THEN
24095: --UPD END
24096: hr_utility.set_location(' BEN_LVG_RSN_RT_F UPDATE_LVG_RSN_RT ',30);
24097: BEN_LVG_RSN_RT_API.UPDATE_LVG_RSN_RT(
24098: --
24099: P_VALIDATE => false
24100: ,P_EFFECTIVE_DATE => l_effective_date