eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_CMBN_AGE_LOS_FCTR

Line 5871: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_FCTR

5867: from ben_copy_entity_results cpe,
5868: pqh_table_route tr
5869: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5870: and cpe.table_route_id = tr.table_route_id
5871: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_FCTR
5872: and tr.table_alias = l_table_alias
5873: and cpe.number_of_copies = 1 --ADDITION
5874: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5875: order by information1, information2; --added for bug: 5151945

Line 5907: from BEN_CMBN_AGE_LOS_FCTR CLA

5903: c_business_group_id number,
5904: c_new_pk_id number) is
5905: select
5906: CLA.cmbn_age_los_fctr_id new_value
5907: from BEN_CMBN_AGE_LOS_FCTR CLA
5908: where CLA.name = c_CLA_name
5909: and CLA.business_group_id = c_business_group_id
5910: and CLA.cmbn_age_los_fctr_id <> c_new_pk_id
5911: ;

Line 6058: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_AGE_LOS_FCTR',l_prefix || r_CLA.INFORMATION170 || l_suffix);

6054: if l_AGE_FCTR_ID is null and l_LOS_FCTR_ID is null then
6055: l_first_rec:=false;
6056: end if;
6057: --
6058: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_AGE_LOS_FCTR',l_prefix || r_CLA.INFORMATION170 || l_suffix);
6059: --
6060: if l_first_rec and not l_update then
6061: -- Call Create routine.
6062: hr_utility.set_location(' BEN_CMBN_AGE_LOS_FCTR CREATE_CMBN_AGE_LOS_FCTR ',20);

Line 6062: hr_utility.set_location(' BEN_CMBN_AGE_LOS_FCTR CREATE_CMBN_AGE_LOS_FCTR ',20);

6058: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_AGE_LOS_FCTR',l_prefix || r_CLA.INFORMATION170 || l_suffix);
6059: --
6060: if l_first_rec and not l_update then
6061: -- Call Create routine.
6062: hr_utility.set_location(' BEN_CMBN_AGE_LOS_FCTR CREATE_CMBN_AGE_LOS_FCTR ',20);
6063: BEN_CMBN_AGE_LOS_FCTR_API.CREATE_CMBN_AGE_LOS_FCTR(
6064: --
6065: P_VALIDATE => false
6066: -- ,P_EFFECTIVE_DATE => p_effective_date

Line 6063: BEN_CMBN_AGE_LOS_FCTR_API.CREATE_CMBN_AGE_LOS_FCTR(

6059: --
6060: if l_first_rec and not l_update then
6061: -- Call Create routine.
6062: hr_utility.set_location(' BEN_CMBN_AGE_LOS_FCTR CREATE_CMBN_AGE_LOS_FCTR ',20);
6063: BEN_CMBN_AGE_LOS_FCTR_API.CREATE_CMBN_AGE_LOS_FCTR(
6064: --
6065: P_VALIDATE => false
6066: -- ,P_EFFECTIVE_DATE => p_effective_date
6067: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 6129: hr_utility.set_location(' BEN_CMBN_AGE_LOS_FCTR UPDATE_CMBN_AGE_LOS_FCTR ',20);

6125: log_data('CLA',l_new_value,l_prefix || r_CLA.INFORMATION170 || l_suffix,'COPIED');
6126: --
6127: elsif l_update then
6128:
6129: hr_utility.set_location(' BEN_CMBN_AGE_LOS_FCTR UPDATE_CMBN_AGE_LOS_FCTR ',20);
6130: BEN_CMBN_AGE_LOS_FCTR_API.UPDATE_CMBN_AGE_LOS_FCTR(
6131: --
6132: P_VALIDATE => false
6133: -- ,P_EFFECTIVE_DATE => p_effective_date

Line 6130: BEN_CMBN_AGE_LOS_FCTR_API.UPDATE_CMBN_AGE_LOS_FCTR(

6126: --
6127: elsif l_update then
6128:
6129: hr_utility.set_location(' BEN_CMBN_AGE_LOS_FCTR UPDATE_CMBN_AGE_LOS_FCTR ',20);
6130: BEN_CMBN_AGE_LOS_FCTR_API.UPDATE_CMBN_AGE_LOS_FCTR(
6131: --
6132: P_VALIDATE => false
6133: -- ,P_EFFECTIVE_DATE => p_effective_date
6134: ,P_BUSINESS_GROUP_ID => p_target_business_group_id