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_PRTL_MO_RT_PRTN_VAL_F

Line 15475: -- and tr.where_clause = l_BEN_PRTL_MO_RT_PRTN_VAL_F

15471: from ben_copy_entity_results cpe,
15472: pqh_table_route tr
15473: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15474: and cpe.table_route_id = tr.table_route_id
15475: -- and tr.where_clause = l_BEN_PRTL_MO_RT_PRTN_VAL_F
15476: and tr.table_alias = l_table_alias
15477: and cpe.number_of_copies = 1 -- ADDITION
15478: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15479: order by information1, information2; --added for bug: 5151945

Line 15513: from BEN_PRTL_MO_RT_PRTN_VAL_F PMRPV

15509: c_business_group_id number,
15510: c_new_pk_id number) is
15511: select
15512: PMRPV.prtl_mo_rt_prtn_val_id new_value
15513: from BEN_PRTL_MO_RT_PRTN_VAL_F PMRPV
15514: where
15515: NVL(PMRPV.RNDG_CD,-999) = NVL(l_RNDG_CD,-999) and
15516: NVL(PMRPV.TO_DY_MO_NUM,-999) = NVL(l_TO_DY_MO_NUM,-999) and
15517: NVL(PMRPV.FROM_DY_MO_NUM,-999) = NVL(l_FROM_DY_MO_NUM,-999) and

Line 15533: from BEN_PRTL_MO_RT_PRTN_VAL_F PMRPV1

15529: and effective_end_date ;
15530: --END TEMPIK
15531: /*TEMPIK
15532: and exists ( select null
15533: from BEN_PRTL_MO_RT_PRTN_VAL_F PMRPV1
15534: where
15535: NVL(PMRPV1.RNDG_CD,-999) = NVL(l_RNDG_CD,-999) and
15536: NVL(PMRPV1.TO_DY_MO_NUM,-999) = NVL(l_TO_DY_MO_NUM,-999) and
15537: NVL(PMRPV1.FROM_DY_MO_NUM,-999) = NVL(l_FROM_DY_MO_NUM,-999) and

Line 15548: from BEN_PRTL_MO_RT_PRTN_VAL_F PMRPV2

15544: NVL(PMRPV1.ACTY_BASE_RT_ID,-999) = NVL(l_ACTY_BASE_RT_ID,-999) and
15545: PMRPV1.business_group_id = c_business_group_id
15546: and PMRPV1.effective_start_date <= c_effective_start_date )
15547: and exists ( select null
15548: from BEN_PRTL_MO_RT_PRTN_VAL_F PMRPV2
15549: where
15550: NVL(PMRPV2.RNDG_CD,-999) = NVL(l_RNDG_CD,-999) and
15551: NVL(PMRPV2.TO_DY_MO_NUM,-999) = NVL(l_TO_DY_MO_NUM,-999) and
15552: NVL(PMRPV2.FROM_DY_MO_NUM,-999) = NVL(l_FROM_DY_MO_NUM,-999) and

Line 15705: (p_base_table_name => 'BEN_PRTL_MO_RT_PRTN_VAL_F',

15701: fetch c_find_PMRPV_in_target into l_new_value ;
15702: if c_find_PMRPV_in_target%found then
15703: --TEMPIK
15704: l_dt_rec_found := dt_api.check_min_max_dates
15705: (p_base_table_name => 'BEN_PRTL_MO_RT_PRTN_VAL_F',
15706: p_base_key_column => 'PRTL_MO_RT_PRTN_VAL_ID',
15707: p_base_key_value => l_new_value,
15708: p_from_date => l_min_esd,
15709: p_to_date => l_max_eed );

Line 15768: hr_utility.set_location(' BEN_PRTL_MO_RT_PRTN_VAL_F CREATE_PRTL_MO_RT_PRTN_VAL ',20);

15764:
15765: --if l_first_rec then
15766: if l_first_rec and not l_update then
15767: -- Call Create routine.
15768: hr_utility.set_location(' BEN_PRTL_MO_RT_PRTN_VAL_F CREATE_PRTL_MO_RT_PRTN_VAL ',20);
15769: BEN_PRTL_MO_RT_PRTN_VAL_API.CREATE_PRTL_MO_RT_PRTN_VAL(
15770: --
15771: P_VALIDATE => false
15772: ,P_EFFECTIVE_DATE => l_effective_date

Line 15847: hr_utility.set_location(' BEN_PRTL_MO_RT_PRTN_VAL_F UPDATE_PRTL_MO_RT_PRTN_VAL ',30);

15843: else
15844: --
15845: -- Call Update routine for the pk_id created in prev run .
15846: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
15847: hr_utility.set_location(' BEN_PRTL_MO_RT_PRTN_VAL_F UPDATE_PRTL_MO_RT_PRTN_VAL ',30);
15848: --UPD START
15849: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15850: --
15851: if l_update then