APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_QUA_IN_GR_RT_F

Line 25191: -- and tr.where_clause = l_BEN_QUA_IN_GR_RT_F

25187: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25188: pqh_table_route tr
25189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25190: and cpe.table_route_id = tr.table_route_id
25191: -- and tr.where_clause = l_BEN_QUA_IN_GR_RT_F
25192: and tr.table_alias = l_table_alias
25193: and cpe.number_of_copies = 1 -- ADDITION
25194: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
25195: order by information1, information2; --added for bug: 5151945

Line 25229: from BEN_QUA_IN_GR_RT_F QIG

25225: c_business_group_id number,
25226: c_new_pk_id number) is
25227: select
25228: QIG.qua_in_gr_rt_id new_value
25229: from BEN_QUA_IN_GR_RT_F QIG
25230: where
25231: QIG.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
25232: QIG.QUAR_IN_GRADE_CD = l_QUAR_IN_GRADE_CD and
25233: QIG.ORDR_NUM = l_ORDR_NUM and

Line 25242: from BEN_QUA_IN_GR_RT_F QIG1

25238: and effective_end_date ;
25239: --END TEMPIK
25240: /*TEMPIK
25241: and exists ( select null
25242: from BEN_QUA_IN_GR_RT_F QIG1
25243: where
25244: QIG1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
25245: QIG1.QUAR_IN_GRADE_CD = l_QUAR_IN_GRADE_CD and
25246: QIG1.ORDR_NUM = l_ORDR_NUM and

Line 25250: from BEN_QUA_IN_GR_RT_F QIG2

25246: QIG1.ORDR_NUM = l_ORDR_NUM and
25247: QIG1.business_group_id = c_business_group_id
25248: and QIG1.effective_start_date <= c_effective_start_date )
25249: and exists ( select null
25250: from BEN_QUA_IN_GR_RT_F QIG2
25251: where
25252: QIG2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
25253: QIG2.QUAR_IN_GRADE_CD = l_QUAR_IN_GRADE_CD and
25254: QIG2.ORDR_NUM = l_ORDR_NUM and

Line 25389: (p_base_table_name => 'BEN_QUA_IN_GR_RT_F',

25385: if c_find_QIG_in_target%found then
25386: --
25387: --TEMPIK
25388: l_dt_rec_found := dt_api.check_min_max_dates
25389: (p_base_table_name => 'BEN_QUA_IN_GR_RT_F',
25390: p_base_key_column => 'QUA_IN_GR_RT_ID',
25391: p_base_key_value => l_new_value,
25392: p_from_date => l_min_esd,
25393: p_to_date => l_max_eed );

Line 25447: hr_utility.set_location(' BEN_QUA_IN_GR_RT_F CREATE_QUA_IN_GR_RT ',20);

25443: end if;
25444:
25445: if l_first_rec and not l_update then
25446: -- Call Create routine.
25447: hr_utility.set_location(' BEN_QUA_IN_GR_RT_F CREATE_QUA_IN_GR_RT ',20);
25448: BEN_QUA_IN_GR_RT_API.CREATE_QUA_IN_GR_RT(
25449: --
25450: P_VALIDATE => false
25451: ,P_EFFECTIVE_DATE => l_effective_date

Line 25539: hr_utility.set_location(' BEN_QUA_IN_GR_RT_F UPDATE_QUA_IN_GR_RT ',30);

25535: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
25536: --
25537: IF l_update OR l_dml_operation <> 'UPDATE' THEN
25538: --UPD END
25539: hr_utility.set_location(' BEN_QUA_IN_GR_RT_F UPDATE_QUA_IN_GR_RT ',30);
25540: BEN_QUA_IN_GR_RT_API.UPDATE_QUA_IN_GR_RT(
25541: --
25542: P_VALIDATE => false
25543: ,P_EFFECTIVE_DATE => l_effective_date