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_PLIP_F

Line 1945: -- and tr.where_clause = l_BEN_CMBN_PLIP_F

1941: from ben_copy_entity_results cpe,
1942: pqh_table_route tr
1943: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1944: and cpe.table_route_id = tr.table_route_id
1945: -- and tr.where_clause = l_BEN_CMBN_PLIP_F
1946: and tr.table_alias = l_table_alias
1947: and cpe.number_of_copies = 1 -- ADDITION
1948: group by cpe.information1,cpe.information2,cpe.information3, cpe.information170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
1949: order by information1, information2; --added for bug: 5151945

Line 1983: from BEN_CMBN_PLIP_F CPL

1979: c_business_group_id number,
1980: c_new_pk_id number) is
1981: select
1982: CPL.cmbn_plip_id new_value
1983: from BEN_CMBN_PLIP_F CPL
1984: where CPL.name = c_CPL_name and
1985: nvl(CPL.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
1986: CPL.business_group_id = c_business_group_id
1987: and CPL.cmbn_plip_id <> c_new_pk_id

Line 1994: from BEN_CMBN_PLIP_F CPL1

1990: and effective_end_date ;
1991: --END TEMPIK
1992: /*TEMPIK
1993: and exists ( select null
1994: from BEN_CMBN_PLIP_F CPL1
1995: where CPL1.name = c_CPL_name and
1996: nvl(CPL1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
1997: CPL1.business_group_id = c_business_group_id
1998: and CPL1.effective_start_date <= c_effective_start_date )

Line 2000: from BEN_CMBN_PLIP_F CPL2

1996: nvl(CPL1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
1997: CPL1.business_group_id = c_business_group_id
1998: and CPL1.effective_start_date <= c_effective_start_date )
1999: and exists ( select null
2000: from BEN_CMBN_PLIP_F CPL2
2001: where CPL2.name = c_CPL_name and
2002: nvl(CPL2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2003: CPL2.business_group_id = c_business_group_id
2004: and CPL2.effective_end_date >= c_effective_end_date )

Line 2020: from BEN_CMBN_PLIP_F CPL

2016: c_business_group_id number,
2017: c_new_pk_id number) is
2018: select
2019: CPL.cmbn_plip_id new_value
2020: from BEN_CMBN_PLIP_F CPL
2021: where CPL.name = c_CPL_name and
2022: CPL.business_group_id = c_business_group_id
2023: and CPL.cmbn_plip_id <> c_new_pk_id
2024: and exists ( select null

Line 2025: from BEN_CMBN_PLIP_F CPL1

2021: where CPL.name = c_CPL_name and
2022: CPL.business_group_id = c_business_group_id
2023: and CPL.cmbn_plip_id <> c_new_pk_id
2024: and exists ( select null
2025: from BEN_CMBN_PLIP_F CPL1
2026: where CPL1.name = c_CPL_name and
2027: CPL1.business_group_id = c_business_group_id
2028: and CPL1.effective_start_date <= c_effective_start_date )
2029: and exists ( select null

Line 2030: from BEN_CMBN_PLIP_F CPL2

2026: where CPL1.name = c_CPL_name and
2027: CPL1.business_group_id = c_business_group_id
2028: and CPL1.effective_start_date <= c_effective_start_date )
2029: and exists ( select null
2030: from BEN_CMBN_PLIP_F CPL2
2031: where CPL2.name = c_CPL_name and
2032: CPL2.business_group_id = c_business_group_id
2033: and CPL2.effective_end_date >= c_effective_end_date )
2034: ;

Line 2170: (p_base_table_name => 'BEN_CMBN_PLIP_F',

2166: if c_find_CPL_in_target%found then
2167: --
2168: --TEMPIK
2169: l_dt_rec_found := dt_api.check_min_max_dates
2170: (p_base_table_name => 'BEN_CMBN_PLIP_F',
2171: p_base_key_column => 'CMBN_PLIP_ID',
2172: p_base_key_value => l_new_value,
2173: p_from_date => l_min_esd,
2174: p_to_date => l_max_eed );

Line 2251: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_PLIP_F' ,l_prefix || r_CPL.information170 || l_suffix);

2247: l_first_rec := true ;
2248: --
2249: end if ;
2250: --
2251: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_PLIP_F' ,l_prefix || r_CPL.information170 || l_suffix);
2252: --
2253:
2254: l_effective_date := r_CPL.information2;
2255: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 2262: hr_utility.set_location(' BEN_CMBN_PLIP_F CREATE_CMBN_PLIP ',20);

2258: end if;
2259:
2260: if l_first_rec and not l_update then
2261: -- Call Create routine.
2262: hr_utility.set_location(' BEN_CMBN_PLIP_F CREATE_CMBN_PLIP ',20);
2263: BEN_CMBN_PLIP_API.CREATE_CMBN_PLIP(
2264: --
2265: P_VALIDATE => false
2266: ,P_EFFECTIVE_DATE => l_effective_date

Line 2353: hr_utility.set_location(' BEN_CMBN_PLIP_F UPDATE_CMBN_PLIP ',30);

2349: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
2350: --
2351: IF l_update OR l_dml_operation <> 'UPDATE' THEN
2352: --UPD END
2353: hr_utility.set_location(' BEN_CMBN_PLIP_F UPDATE_CMBN_PLIP ',30);
2354: BEN_CMBN_PLIP_API.UPDATE_CMBN_PLIP(
2355: --
2356: P_VALIDATE => false
2357: ,P_EFFECTIVE_DATE => l_effective_date