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_FIVE dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 5875: -- and tr.where_clause = l_BEN_CVG_AMT_CALC_MTHD_F

5871: from ben_copy_entity_results cpe,
5872: pqh_table_route tr
5873: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5874: and cpe.table_route_id = tr.table_route_id
5875: -- and tr.where_clause = l_BEN_CVG_AMT_CALC_MTHD_F
5876: and tr.table_alias = l_table_alias
5877: and cpe.number_of_copies = 1 -- ADDITION
5878: group by cpe.information1,cpe.information2,cpe.information3, cpe.information170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5879: order by information1, information2; --added for bug: 5151945

Line 5913: from BEN_CVG_AMT_CALC_MTHD_F CCM

5909: c_business_group_id number,
5910: c_new_pk_id number) is
5911: select
5912: CCM.cvg_amt_calc_mthd_id new_value
5913: from BEN_CVG_AMT_CALC_MTHD_F CCM
5914: where CCM.name = c_CCM_name and
5915: nvl(CCM.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
5916: nvl(CCM.PLIP_ID,-999) = nvl(l_PLIP_ID,-999) and
5917: nvl(CCM.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 5926: from BEN_CVG_AMT_CALC_MTHD_F CCM1

5922: and effective_end_date ;
5923: --END TEMPIK
5924: /*TEMPIK
5925: and exists ( select null
5926: from BEN_CVG_AMT_CALC_MTHD_F CCM1
5927: where CCM1.name = c_CCM_name and
5928: nvl(CCM1.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
5929: nvl(CCM1.PLIP_ID,-999) = nvl(l_PLIP_ID,-999) and
5930: nvl(CCM1.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 5934: from BEN_CVG_AMT_CALC_MTHD_F CCM2

5930: nvl(CCM1.PL_ID,-999) = nvl(l_PL_ID,-999) and
5931: CCM1.business_group_id = c_business_group_id
5932: and CCM1.effective_start_date <= c_effective_start_date )
5933: and exists ( select null
5934: from BEN_CVG_AMT_CALC_MTHD_F CCM2
5935: where CCM2.name = c_CCM_name and
5936: nvl(CCM2.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
5937: nvl(CCM2.PLIP_ID,-999) = nvl(l_PLIP_ID,-999) and
5938: nvl(CCM2.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 5955: from BEN_CVG_AMT_CALC_MTHD_F CCM

5951: c_business_group_id number,
5952: c_new_pk_id number) is
5953: select
5954: CCM.cvg_amt_calc_mthd_id new_value
5955: from BEN_CVG_AMT_CALC_MTHD_F CCM
5956: where CCM.name = c_CCM_name and
5957: CCM.business_group_id = c_business_group_id
5958: and CCM.cvg_amt_calc_mthd_id <> c_new_pk_id
5959: --TEMPIK

Line 5965: from BEN_CVG_AMT_CALC_MTHD_F CCM1

5961: and effective_end_date ;
5962: --END TEMPIK
5963: /*TEMPIK
5964: and exists ( select null
5965: from BEN_CVG_AMT_CALC_MTHD_F CCM1
5966: where CCM1.name = c_CCM_name and
5967: CCM1.business_group_id = c_business_group_id
5968: and CCM1.effective_start_date <= c_effective_start_date )
5969: and exists ( select null

Line 5970: from BEN_CVG_AMT_CALC_MTHD_F CCM2

5966: where CCM1.name = c_CCM_name and
5967: CCM1.business_group_id = c_business_group_id
5968: and CCM1.effective_start_date <= c_effective_start_date )
5969: and exists ( select null
5970: from BEN_CVG_AMT_CALC_MTHD_F CCM2
5971: where CCM2.name = c_CCM_name and
5972: CCM2.business_group_id = c_business_group_id
5973: and CCM2.effective_end_date >= c_effective_end_date )
5974: ;

Line 6111: (p_base_table_name => 'BEN_CVG_AMT_CALC_MTHD_F',

6107: fetch c_find_CCM_in_target into l_new_value ;
6108: if c_find_CCM_in_target%found then
6109: --TEMPIK
6110: l_dt_rec_found := dt_api.check_min_max_dates
6111: (p_base_table_name => 'BEN_CVG_AMT_CALC_MTHD_F',
6112: p_base_key_column => 'CVG_AMT_CALC_MTHD_ID',
6113: p_base_key_value => l_new_value,
6114: p_from_date => l_min_esd,
6115: p_to_date => l_max_eed );

Line 6148: (p_base_table_name => 'BEN_CVG_AMT_CALC_MTHD_F',

6144: if c_find_CCM_name_in_target%found then
6145: --
6146: --TEMPIK
6147: l_dt_rec_found := dt_api.check_min_max_dates
6148: (p_base_table_name => 'BEN_CVG_AMT_CALC_MTHD_F',
6149: p_base_key_column => 'CVG_AMT_CALC_MTHD_ID',
6150: p_base_key_value => l_new_value,
6151: p_from_date => l_min_esd,
6152: p_to_date => l_max_eed );

Line 6201: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CVG_AMT_CALC_MTHD_F',l_prefix || r_CCM.information170 || l_suffix);

6197: l_first_rec := true ;
6198: --
6199: end if ;
6200: --
6201: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CVG_AMT_CALC_MTHD_F',l_prefix || r_CCM.information170 || l_suffix);
6202: --
6203:
6204: l_effective_date := r_CCM.information2;
6205: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 6216: hr_utility.set_location(' BEN_CVG_AMT_CALC_MTHD_F CREATE_CVG_AMT_CALC ',20);

6212: if l_first_rec and not l_update then
6213: -- UPD END
6214:
6215: -- Call Create routine.
6216: hr_utility.set_location(' BEN_CVG_AMT_CALC_MTHD_F CREATE_CVG_AMT_CALC ',20);
6217: BEN_CVG_AMT_CALC_API.CREATE_CVG_AMT_CALC(
6218: --
6219: P_VALIDATE => false
6220: ,P_EFFECTIVE_DATE => l_effective_date

Line 6308: hr_utility.set_location(' BEN_CVG_AMT_CALC_MTHD_F UPDATE_CVG_AMT_CALC ',30);

6304: else
6305: --
6306: -- Call Update routine for the pk_id created in prev run .
6307: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
6308: hr_utility.set_location(' BEN_CVG_AMT_CALC_MTHD_F UPDATE_CVG_AMT_CALC ',30);
6309: --UPD START
6310: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
6311: --
6312: if l_update then