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_PL_TYP_F

Line 6217: -- and tr.where_clause = l_BEN_PL_TYP_F

6213: from ben_copy_entity_results cpe,
6214: pqh_table_route tr
6215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6216: and cpe.table_route_id = tr.table_route_id
6217: -- and tr.where_clause = l_BEN_PL_TYP_F
6218: and tr.table_alias = l_table_alias
6219: and cpe.number_of_copies = 1 --ADDITION
6220: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6221: order by information1, information2; --added for bug: 5151945

Line 6255: from BEN_PL_TYP_F PTP

6251: c_business_group_id number,
6252: c_new_pk_id number) is
6253: select
6254: PTP.pl_typ_id new_value
6255: from BEN_PL_TYP_F PTP
6256: where PTP.name = c_PTP_name
6257: and PTP.business_group_id = c_business_group_id
6258: and PTP.pl_typ_id <> c_new_pk_id
6259: --TEMPIK

Line 6265: from BEN_PL_TYP_F PTP1

6261: and effective_end_date ;
6262: --END TEMPIK
6263: /*TEMPIK
6264: and exists ( select null
6265: from BEN_PL_TYP_F PTP1
6266: where PTP1.name = c_PTP_name
6267: and PTP1.business_group_id = c_business_group_id
6268: and PTP1.effective_start_date <= c_effective_start_date )
6269: and exists ( select null

Line 6270: from BEN_PL_TYP_F PTP2

6266: where PTP1.name = c_PTP_name
6267: and PTP1.business_group_id = c_business_group_id
6268: and PTP1.effective_start_date <= c_effective_start_date )
6269: and exists ( select null
6270: from BEN_PL_TYP_F PTP2
6271: where PTP2.name = c_PTP_name
6272: and PTP2.business_group_id = c_business_group_id
6273: and PTP2.effective_end_date >= c_effective_end_date )
6274: ;

Line 6400: (p_base_table_name => 'BEN_PL_TYP_F',

6396: if c_find_PTP_in_target%found then
6397: --
6398: --TEMPIK
6399: l_dt_rec_found := dt_api.check_min_max_dates
6400: (p_base_table_name => 'BEN_PL_TYP_F',
6401: p_base_key_column => 'PL_TYP_ID',
6402: p_base_key_value => l_new_value,
6403: p_from_date => l_min_esd,
6404: p_to_date => l_max_eed );

Line 6462: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PL_TYP_F',l_prefix || r_PTP.INFORMATION170 || l_suffix);

6458: l_first_rec := true ;
6459: --
6460: end if ;
6461: --
6462: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PL_TYP_F',l_prefix || r_PTP.INFORMATION170 || l_suffix);
6463: --
6464:
6465: l_effective_date := r_PTP.information2;
6466: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 6473: hr_utility.set_location(' BEN_PL_TYP_F CREATE_PLAN_TYPE ',20);

6469: end if;
6470:
6471: if l_first_rec and not l_update then
6472: -- Call Create routine.
6473: hr_utility.set_location(' BEN_PL_TYP_F CREATE_PLAN_TYPE ',20);
6474: BEN_PLAN_TYPE_API.CREATE_PLAN_TYPE(
6475: --
6476: P_VALIDATE => false
6477: ,P_EFFECTIVE_DATE => l_effective_date

Line 6572: hr_utility.set_location(' BEN_PL_TYP_F UPDATE_PLAN_TYPE ',30);

6568: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
6569: -- Call Update routine for the pk_id created in prev run .
6570: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
6571: IF l_update OR l_dml_operation <> 'UPDATE' THEN
6572: hr_utility.set_location(' BEN_PL_TYP_F UPDATE_PLAN_TYPE ',30);
6573: BEN_PLAN_TYPE_API.UPDATE_PLAN_TYPE(
6574: --
6575: P_VALIDATE => false
6576: ,P_EFFECTIVE_DATE => l_effective_date