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_ACTY_BASE_RT_F

Line 2117: -- and tr.where_clause = l_BEN_ACTY_BASE_RT_F

2113: from ben_copy_entity_results cpe,
2114: pqh_table_route tr
2115: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2116: and cpe.table_route_id = tr.table_route_id
2117: -- and tr.where_clause = l_BEN_ACTY_BASE_RT_F
2118: and tr.table_alias = l_table_alias
2119: and cpe.number_of_copies = 1 -- ADDITION
2120: group by cpe.information169, cpe.information1, cpe.information2, cpe.information3,
2121: cpe.information170, cpe.table_route_id ,cpe.dml_operation, cpe.datetrack_mode

Line 2157: from BEN_ACTY_BASE_RT_F ABR

2153: c_business_group_id number,
2154: c_new_pk_id number) is
2155: select
2156: ABR.acty_base_rt_id new_value
2157: from BEN_ACTY_BASE_RT_F ABR
2158: where ABR.name = c_ABR_name and
2159: nvl(ABR.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999) and
2160: nvl(ABR.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999) and
2161: nvl(ABR.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999) and

Line 2179: from BEN_ACTY_BASE_RT_F ABR1

2175: and effective_end_date ;
2176: --END TEMPIK
2177: /*TEMPIK
2178: and exists ( select null
2179: from BEN_ACTY_BASE_RT_F ABR1
2180: where ABR1.name = c_ABR_name and
2181: nvl(ABR1.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999) and
2182: nvl(ABR1.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999) and
2183: nvl(ABR1.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999) and

Line 2194: from BEN_ACTY_BASE_RT_F ABR2

2190: nvl(ABR1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
2191: ABR1.business_group_id = c_business_group_id
2192: and ABR1.effective_start_date <= c_effective_start_date )
2193: and exists ( select null
2194: from BEN_ACTY_BASE_RT_F ABR2
2195: where ABR2.name = c_ABR_name and
2196: nvl(ABR2.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999) and
2197: nvl(ABR2.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999) and
2198: nvl(ABR2.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999) and

Line 2218: from BEN_ACTY_BASE_RT_F ABR

2214: c_business_group_id number,
2215: c_new_pk_id number) is
2216: select
2217: ABR.acty_base_rt_id new_value
2218: from BEN_ACTY_BASE_RT_F ABR
2219: where ABR.name = c_ABR_name and
2220: ABR.business_group_id = c_business_group_id
2221: and ABR.acty_base_rt_id <> c_new_pk_id
2222: --TEMPIK

Line 2228: from BEN_ACTY_BASE_RT_F ABR1

2224: and effective_end_date ;
2225: --END TEMPIK
2226: /*TEMPIK
2227: and exists ( select null
2228: from BEN_ACTY_BASE_RT_F ABR1
2229: where ABR1.name = c_ABR_name and
2230: ABR1.business_group_id = c_business_group_id
2231: and ABR1.effective_start_date <= c_effective_start_date )
2232: and exists ( select null

Line 2233: from BEN_ACTY_BASE_RT_F ABR2

2229: where ABR1.name = c_ABR_name and
2230: ABR1.business_group_id = c_business_group_id
2231: and ABR1.effective_start_date <= c_effective_start_date )
2232: and exists ( select null
2233: from BEN_ACTY_BASE_RT_F ABR2
2234: where ABR2.name = c_ABR_name and
2235: ABR2.business_group_id = c_business_group_id
2236: and ABR2.effective_end_date >= c_effective_end_date )
2237: ;

Line 2512: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',

2508: fetch c_find_ABR_in_target into l_new_value ;
2509: if c_find_ABR_in_target%found then
2510: --TEMPIK
2511: l_dt_rec_found := dt_api.check_min_max_dates
2512: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',
2513: p_base_key_column => 'ACTY_BASE_RT_ID',
2514: p_base_key_value => l_new_value,
2515: p_from_date => l_min_esd,
2516: p_to_date => l_max_eed );

Line 2552: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',

2548: fetch c_find_ABR_name_in_target into l_new_value ;
2549: if c_find_ABR_name_in_target%found then
2550: --TEMPIK
2551: l_dt_rec_found := dt_api.check_min_max_dates
2552: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',
2553: p_base_key_column => 'ACTY_BASE_RT_ID',
2554: p_base_key_value => l_new_value,
2555: p_from_date => l_min_esd,
2556: p_to_date => l_max_eed );

Line 2608: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_ACTY_BASE_RT_F',l_prefix || r_ABR.INFORMATION170 || l_suffix);

2604: l_first_rec := true ;
2605: --
2606: end if ;
2607: --
2608: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_ACTY_BASE_RT_F',l_prefix || r_ABR.INFORMATION170 || l_suffix);
2609: --
2610:
2611: l_effective_date := r_ABR.information2;
2612: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 2621: hr_utility.set_location(' BEN_ACTY_BASE_RT_F CREATE_ACTY_BASE_RATE ',20);

2617: --if l_first_rec then
2618: if l_first_rec and not l_update then
2619: -- UPD END
2620: -- Call Create routine.
2621: hr_utility.set_location(' BEN_ACTY_BASE_RT_F CREATE_ACTY_BASE_RATE ',20);
2622: BEN_ACTY_BASE_RATE_API.CREATE_ACTY_BASE_RATE(
2623: --
2624: P_VALIDATE => false
2625: ,P_EFFECTIVE_DATE => l_effective_date

Line 2803: hr_utility.set_location(' BEN_ACTY_BASE_RT_F UPDATE_ACTY_BASE_RATE ',30);

2799: else
2800: --
2801: -- Call Update routine for the pk_id created in prev run .
2802: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
2803: hr_utility.set_location(' BEN_ACTY_BASE_RT_F UPDATE_ACTY_BASE_RATE ',30);
2804:
2805: --UPD START
2806: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
2807: --