APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_PSTN_RT_F

Line 20946: -- and tr.where_clause = l_BEN_PSTN_RT_F

20942: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20943: pqh_table_route tr
20944: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20945: and cpe.table_route_id = tr.table_route_id
20946: -- and tr.where_clause = l_BEN_PSTN_RT_F
20947: and tr.table_alias = l_table_alias
20948: and cpe.number_of_copies = 1 -- ADDITION
20949: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
20950: order by information1, information2; --added for bug: 5151945

Line 20984: from BEN_PSTN_RT_F PST

20980: c_business_group_id number,
20981: c_new_pk_id number) is
20982: select
20983: PST.pstn_rt_id new_value
20984: from BEN_PSTN_RT_F PST
20985: where
20986: PST.POSITION_ID = l_POSITION_ID and
20987: PST.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
20988: PST.ORDR_NUM = l_ORDR_NUM and

Line 20997: from BEN_PSTN_RT_F PST1

20993: and effective_end_date ;
20994: --END TEMPIK
20995: /*TEMPIK
20996: and exists ( select null
20997: from BEN_PSTN_RT_F PST1
20998: where
20999: PST1.POSITION_ID = l_POSITION_ID and
21000: PST1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
21001: PST1.ORDR_NUM = l_ORDR_NUM and

Line 21005: from BEN_PSTN_RT_F PST2

21001: PST1.ORDR_NUM = l_ORDR_NUM and
21002: PST1.business_group_id = c_business_group_id
21003: and PST1.effective_start_date <= c_effective_start_date )
21004: and exists ( select null
21005: from BEN_PSTN_RT_F PST2
21006: where
21007: PST2.POSITION_ID = l_POSITION_ID and
21008: PST2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
21009: PST2.ORDR_NUM = l_ORDR_NUM and

Line 21162: (p_base_table_name => 'BEN_PSTN_RT_F',

21158: if c_find_PST_in_target%found then
21159: --
21160: --TEMPIK
21161: l_dt_rec_found := dt_api.check_min_max_dates
21162: (p_base_table_name => 'BEN_PSTN_RT_F',
21163: p_base_key_column => 'PSTN_RT_ID',
21164: p_base_key_value => l_new_value,
21165: p_from_date => l_min_esd,
21166: p_to_date => l_max_eed );

Line 21220: hr_utility.set_location(' BEN_PSTN_RT_F CREATE_PSTN_RT ',20);

21216: end if;
21217:
21218: if l_first_rec and not l_update then
21219: -- Call Create routine.
21220: hr_utility.set_location(' BEN_PSTN_RT_F CREATE_PSTN_RT ',20);
21221: BEN_PSTN_RT_API.CREATE_PSTN_RT(
21222: --
21223: P_VALIDATE => false
21224: ,P_EFFECTIVE_DATE => l_effective_date

Line 21312: hr_utility.set_location(' BEN_PSTN_RT_F UPDATE_PSTN_RT ',30);

21308: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
21309: --
21310: IF l_update OR l_dml_operation <> 'UPDATE' THEN
21311: --UPD END
21312: hr_utility.set_location(' BEN_PSTN_RT_F UPDATE_PSTN_RT ',30);
21313: BEN_PSTN_RT_API.UPDATE_PSTN_RT(
21314: --
21315: P_VALIDATE => false
21316: ,P_EFFECTIVE_DATE => l_effective_date