APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_PPL_GRP_RT_F

Line 26124: -- and tr.where_clause = l_BEN_PPL_GRP_RT_F

26120: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26121: pqh_table_route tr
26122: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26123: and cpe.table_route_id = tr.table_route_id
26124: -- and tr.where_clause = l_BEN_PPL_GRP_RT_F
26125: and tr.table_alias = l_table_alias
26126: and cpe.number_of_copies = 1 -- ADDITION
26127: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
26128: order by information1, information2; --added for bug: 5151945

Line 26162: from BEN_PPL_GRP_RT_F PGR

26158: c_business_group_id number,
26159: c_new_pk_id number) is
26160: select
26161: PGR.ppl_grp_rt_id new_value
26162: from BEN_PPL_GRP_RT_F PGR
26163: where
26164: PGR.PEOPLE_GROUP_ID = l_PEOPLE_GROUP_ID and
26165: PGR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
26166: PGR.business_group_id = c_business_group_id

Line 26174: from BEN_PPL_GRP_RT_F PGR1

26170: and effective_end_date ;
26171: --END TEMPIK
26172: /*TEMPIK
26173: and exists ( select null
26174: from BEN_PPL_GRP_RT_F PGR1
26175: where
26176: PGR1.PEOPLE_GROUP_ID = l_PEOPLE_GROUP_ID and
26177: PGR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
26178: PGR1.business_group_id = c_business_group_id

Line 26181: from BEN_PPL_GRP_RT_F PGR2

26177: PGR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
26178: PGR1.business_group_id = c_business_group_id
26179: and PGR1.effective_start_date <= c_effective_start_date )
26180: and exists ( select null
26181: from BEN_PPL_GRP_RT_F PGR2
26182: where
26183: PGR2.PEOPLE_GROUP_ID = l_PEOPLE_GROUP_ID and
26184: PGR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
26185: PGR2.business_group_id = c_business_group_id

Line 26317: (p_base_table_name => 'BEN_PPL_GRP_RT_F',

26313: if c_find_PGR_in_target%found then
26314: --
26315: --TEMPIK
26316: l_dt_rec_found := dt_api.check_min_max_dates
26317: (p_base_table_name => 'BEN_PPL_GRP_RT_F',
26318: p_base_key_column => 'PPL_GRP_RT_ID',
26319: p_base_key_value => l_new_value,
26320: p_from_date => l_min_esd,
26321: p_to_date => l_max_eed );

Line 26375: hr_utility.set_location(' BEN_PPL_GRP_RT_F CREATE_PEOPLE_GROUP_RATE ',20);

26371: end if;
26372:
26373: if l_first_rec and not l_update then
26374: -- Call Create routine.
26375: hr_utility.set_location(' BEN_PPL_GRP_RT_F CREATE_PEOPLE_GROUP_RATE ',20);
26376: BEN_PEOPLE_GROUP_RATE_API.CREATE_PEOPLE_GROUP_RATE(
26377: --
26378: P_VALIDATE => false
26379: ,P_EFFECTIVE_DATE => l_effective_date

Line 26467: hr_utility.set_location(' BEN_PPL_GRP_RT_F UPDATE_PEOPLE_GROUP_RATE ',30);

26463: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
26464: --
26465: IF l_update OR l_dml_operation <> 'UPDATE' THEN
26466: --UPD END
26467: hr_utility.set_location(' BEN_PPL_GRP_RT_F UPDATE_PEOPLE_GROUP_RATE ',30);
26468: BEN_PEOPLE_GROUP_RATE_API.UPDATE_PEOPLE_GROUP_RATE(
26469: --
26470: P_VALIDATE => false
26471: ,P_EFFECTIVE_DATE => l_effective_date