APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_LOS_RT_F

Line 23297: -- and tr.where_clause = l_BEN_LOS_RT_F

23293: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23294: pqh_table_route tr
23295: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23296: and cpe.table_route_id = tr.table_route_id
23297: -- and tr.where_clause = l_BEN_LOS_RT_F
23298: and tr.table_alias = l_table_alias
23299: and cpe.number_of_copies = 1 -- ADDITION
23300: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
23301: order by information1, information2; --added for bug: 5151945

Line 23335: from BEN_LOS_RT_F LSR

23331: c_business_group_id number,
23332: c_new_pk_id number) is
23333: select
23334: LSR.los_rt_id new_value
23335: from BEN_LOS_RT_F LSR
23336: where
23337: LSR.LOS_FCTR_ID = l_LOS_FCTR_ID and
23338: LSR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
23339: LSR.business_group_id = c_business_group_id

Line 23347: from BEN_LOS_RT_F LSR1

23343: and effective_end_date ;
23344: --END TEMPIK
23345: /*TEMPIK
23346: and exists ( select null
23347: from BEN_LOS_RT_F LSR1
23348: where
23349: LSR1.LOS_FCTR_ID = l_LOS_FCTR_ID and
23350: LSR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
23351: LSR1.business_group_id = c_business_group_id

Line 23354: from BEN_LOS_RT_F LSR2

23350: LSR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
23351: LSR1.business_group_id = c_business_group_id
23352: and LSR1.effective_start_date <= c_effective_start_date )
23353: and exists ( select null
23354: from BEN_LOS_RT_F LSR2
23355: where
23356: LSR2.LOS_FCTR_ID = l_LOS_FCTR_ID and
23357: LSR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
23358: LSR2.business_group_id = c_business_group_id

Line 23490: (p_base_table_name => 'BEN_LOS_RT_F',

23486: if c_find_LSR_in_target%found then
23487: --
23488: --TEMPIK
23489: l_dt_rec_found := dt_api.check_min_max_dates
23490: (p_base_table_name => 'BEN_LOS_RT_F',
23491: p_base_key_column => 'LOS_RT_ID',
23492: p_base_key_value => l_new_value,
23493: p_from_date => l_min_esd,
23494: p_to_date => l_max_eed );

Line 23548: hr_utility.set_location(' BEN_LOS_RT_F CREATE_LENGTH_OF_SVC_RATE ',20);

23544: end if;
23545:
23546: if l_first_rec and not l_update then
23547: -- Call Create routine.
23548: hr_utility.set_location(' BEN_LOS_RT_F CREATE_LENGTH_OF_SVC_RATE ',20);
23549: BEN_LENGTH_OF_SVC_RATE_API.CREATE_LENGTH_OF_SVC_RATE(
23550: --
23551: P_VALIDATE => false
23552: ,P_EFFECTIVE_DATE => l_effective_date

Line 23640: hr_utility.set_location(' BEN_LOS_RT_F UPDATE_LENGTH_OF_SVC_RATE ',30);

23636: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
23637: --
23638: IF l_update OR l_dml_operation <> 'UPDATE' THEN
23639: --UPD END
23640: hr_utility.set_location(' BEN_LOS_RT_F UPDATE_LENGTH_OF_SVC_RATE ',30);
23641: BEN_LENGTH_OF_SVC_RATE_API.UPDATE_LENGTH_OF_SVC_RATE(
23642: --
23643: P_VALIDATE => false
23644: ,P_EFFECTIVE_DATE => l_effective_date