APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_QUAL_TITL_RT_F

Line 4519: -- and tr.where_clause = l_BEN_QUAL_TITL_RT_F

4515: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4516: pqh_table_route tr
4517: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4518: and cpe.table_route_id = tr.table_route_id
4519: -- and tr.where_clause = l_BEN_QUAL_TITL_RT_F
4520: and tr.table_alias = l_table_alias
4521: and cpe.number_of_copies = 1 -- ADDITION
4522: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4523: order by information1, information2; --added for bug: 5151945

Line 4557: from BEN_QUAL_TITL_RT_F QTR

4553: c_business_group_id number,
4554: c_new_pk_id number) is
4555: select
4556: QTR.qual_titl_rt_id new_value
4557: from BEN_QUAL_TITL_RT_F QTR
4558: where
4559: QTR.QUALIFICATION_TYPE_ID = l_QUALIFICATION_TYPE_ID and
4560: QTR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
4561: QTR.ORDR_NUM = l_ORDR_NUM and

Line 4570: from BEN_QUAL_TITL_RT_F QTR1

4566: and effective_end_date ;
4567: --END TEMPIK
4568: /*TEMPIK
4569: and exists ( select null
4570: from BEN_QUAL_TITL_RT_F QTR1
4571: where
4572: QTR1.QUALIFICATION_TYPE_ID = l_QUALIFICATION_TYPE_ID and
4573: QTR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
4574: QTR1.ORDR_NUM = l_ORDR_NUM and

Line 4578: from BEN_QUAL_TITL_RT_F QTR2

4574: QTR1.ORDR_NUM = l_ORDR_NUM and
4575: QTR1.business_group_id = c_business_group_id
4576: and QTR1.effective_start_date <= c_effective_start_date )
4577: and exists ( select null
4578: from BEN_QUAL_TITL_RT_F QTR2
4579: where
4580: QTR2.QUALIFICATION_TYPE_ID = l_QUALIFICATION_TYPE_ID and
4581: QTR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
4582: QTR2.ORDR_NUM = l_ORDR_NUM and

Line 4730: (p_base_table_name => 'BEN_QUAL_TITL_RT_F',

4726: if c_find_QTR_in_target%found then
4727: --
4728: --TEMPIK
4729: l_dt_rec_found := dt_api.check_min_max_dates
4730: (p_base_table_name => 'BEN_QUAL_TITL_RT_F',
4731: p_base_key_column => 'QUAL_TITL_RT_ID',
4732: p_base_key_value => l_new_value,
4733: p_from_date => l_min_esd,
4734: p_to_date => l_max_eed );

Line 4788: hr_utility.set_location(' BEN_QUAL_TITL_RT_F CREATE_QUAL_TITL_RT ',20);

4784: end if;
4785:
4786: if l_first_rec and not l_update then
4787: -- Call Create routine.
4788: hr_utility.set_location(' BEN_QUAL_TITL_RT_F CREATE_QUAL_TITL_RT ',20);
4789: BEN_QUAL_TITL_RT_API.CREATE_QUAL_TITL_RT(
4790: --
4791: P_VALIDATE => false
4792: ,P_EFFECTIVE_DATE => l_effective_date

Line 4881: hr_utility.set_location(' BEN_QUAL_TITL_RT_F UPDATE_QUAL_TITL_RT ',30);

4877: --
4878: IF l_update OR l_dml_operation <> 'UPDATE' THEN
4879: --UPD END
4880: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
4881: hr_utility.set_location(' BEN_QUAL_TITL_RT_F UPDATE_QUAL_TITL_RT ',30);
4882: BEN_QUAL_TITL_RT_API.UPDATE_QUAL_TITL_RT(
4883: --
4884: P_VALIDATE => false
4885: ,P_EFFECTIVE_DATE => l_effective_date