APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_POE_RT_F

Line 19986: -- and tr.where_clause = l_BEN_POE_RT_F

19982: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19983: pqh_table_route tr
19984: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19985: and cpe.table_route_id = tr.table_route_id
19986: -- and tr.where_clause = l_BEN_POE_RT_F
19987: and tr.table_alias = l_table_alias
19988: and cpe.number_of_copies = 1 -- ADDITION
19989: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
19990: order by information1, information2; --added for bug: 5151945

Line 20024: from BEN_POE_RT_F PRT

20020: c_business_group_id number,
20021: c_new_pk_id number) is
20022: select
20023: PRT.poe_rt_id new_value
20024: from BEN_POE_RT_F PRT
20025: where
20026: PRT.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
20027: nvl(PRT.RNDG_CD, 'YYYY') = nvl(l_RNDG_CD, 'YYYY') and
20028: nvl(PRT.RNDG_RL, -9999) = nvl(l_RNDG_RL, -9999) and

Line 20042: from BEN_POE_RT_F PRT1

20038: and effective_end_date ;
20039: --END TEMPIK
20040: /*TEMPIK
20041: and exists ( select null
20042: from BEN_POE_RT_F PRT1
20043: where
20044: PRT1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
20045: nvl(PRT1.RNDG_CD, 'YYYY') = nvl(l_RNDG_CD, 'YYYY') and
20046: nvl(PRT1.RNDG_RL, -9999) = nvl(l_RNDG_RL, -9999) and

Line 20055: from BEN_POE_RT_F PRT2

20051: nvl(PRT1.MN_POE_NUM, -9999) = nvl(l_MN_POE_NUM, -9999) and
20052: PRT1.business_group_id = c_business_group_id
20053: and PRT1.effective_start_date <= c_effective_start_date )
20054: and exists ( select null
20055: from BEN_POE_RT_F PRT2
20056: where
20057: PRT2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
20058: nvl(PRT2.RNDG_CD, 'YYYY') = nvl(l_RNDG_CD, 'YYYY') and
20059: nvl(PRT2.RNDG_RL, -9999) = nvl(l_RNDG_RL, -9999) and

Line 20203: (p_base_table_name => 'BEN_POE_RT_F',

20199: if c_find_PRT_in_target%found then
20200: --
20201: --TEMPIK
20202: l_dt_rec_found := dt_api.check_min_max_dates
20203: (p_base_table_name => 'BEN_POE_RT_F',
20204: p_base_key_column => 'POE_RT_ID',
20205: p_base_key_value => l_new_value,
20206: p_from_date => l_min_esd,
20207: p_to_date => l_max_eed );

Line 20261: hr_utility.set_location(' BEN_POE_RT_F CREATE_POE_RT ',20);

20257: end if;
20258:
20259: if l_first_rec and not l_update then
20260: -- Call Create routine.
20261: hr_utility.set_location(' BEN_POE_RT_F CREATE_POE_RT ',20);
20262: BEN_POE_RT_API.CREATE_POE_RT(
20263: --
20264: P_VALIDATE => false
20265: ,P_EFFECTIVE_DATE => l_effective_date

Line 20358: hr_utility.set_location(' BEN_POE_RT_F UPDATE_POE_RT ',30);

20354: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
20355: --
20356: IF l_update OR l_dml_operation <> 'UPDATE' THEN
20357: --UPD END
20358: hr_utility.set_location(' BEN_POE_RT_F UPDATE_POE_RT ',30);
20359: BEN_POE_RT_API.UPDATE_POE_RT(
20360: --
20361: P_VALIDATE => false
20362: ,P_EFFECTIVE_DATE => l_effective_date