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 DT_API

Line 1375: dt_api.check_min_max_dates (p_base_table_name => 'FF_FORMULAS_F',

1371: THEN
1372: --
1373: --TEMPIK
1374: l_dt_rec_found :=
1375: dt_api.check_min_max_dates (p_base_table_name => 'FF_FORMULAS_F',
1376: p_base_key_column => 'FORMULA_ID',
1377: p_base_key_value => l_new_value,
1378: p_from_date => l_min_esd,
1379: p_to_date => l_max_eed

Line 2169: l_dt_rec_found := dt_api.check_min_max_dates

2165: fetch c_find_CPL_in_target into l_new_value ;
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,

Line 2673: l_dt_rec_found := dt_api.check_min_max_dates

2669:
2670: fetch c_find_CBP_in_target into l_new_value ;
2671: if c_find_CBP_in_target%found then
2672: --TEMPIK
2673: l_dt_rec_found := dt_api.check_min_max_dates
2674: (p_base_table_name => 'BEN_CMBN_PTIP_F',
2675: p_base_key_column => 'CMBN_PTIP_ID',
2676: p_base_key_value => l_new_value,
2677: p_from_date => l_min_esd,

Line 3157: l_dt_rec_found := dt_api.check_min_max_dates

3153: fetch c_find_CPT_in_target into l_new_value ;
3154: if c_find_CPT_in_target%found then
3155: --
3156: --TEMPIK
3157: l_dt_rec_found := dt_api.check_min_max_dates
3158: (p_base_table_name => 'BEN_CMBN_PTIP_OPT_F',
3159: p_base_key_column => 'CMBN_PTIP_OPT_ID',
3160: p_base_key_value => l_new_value,
3161: p_from_date => l_min_esd,

Line 3647: l_dt_rec_found := dt_api.check_min_max_dates

3643: fetch c_find_BNB_in_target into l_new_value ;
3644: if c_find_BNB_in_target%found then
3645: --
3646: --TEMPIK
3647: l_dt_rec_found := dt_api.check_min_max_dates
3648: (p_base_table_name => 'BEN_BNFTS_BAL_F',
3649: p_base_key_column => 'BNFTS_BAL_ID',
3650: p_base_key_value => l_new_value,
3651: p_from_date => l_min_esd,

Line 6399: l_dt_rec_found := dt_api.check_min_max_dates

6395: fetch c_find_PTP_in_target into l_new_value ;
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,

Line 6891: l_dt_rec_found := dt_api.check_min_max_dates

6887: fetch c_find_PGM_in_target into l_new_value ;
6888: if c_find_PGM_in_target%found then
6889: --
6890: --TEMPIK
6891: l_dt_rec_found := dt_api.check_min_max_dates
6892: (p_base_table_name => 'BEN_PGM_F',
6893: p_base_key_column => 'PGM_ID',
6894: p_base_key_value => l_new_value,
6895: p_from_date => l_min_esd,

Line 7495: l_dt_rec_found := dt_api.check_min_max_dates

7491: fetch c_find_REG_in_target into l_new_value ;
7492: if c_find_REG_in_target%found then
7493: --
7494: --TEMPIK
7495: l_dt_rec_found := dt_api.check_min_max_dates
7496: (p_base_table_name => 'BEN_REGN_F',
7497: p_base_key_column => 'REGN_ID',
7498: p_base_key_value => l_new_value,
7499: p_from_date => l_min_esd,

Line 7937: l_dt_rec_found := dt_api.check_min_max_dates

7933: fetch c_find_RZR_in_target into l_new_value ;
7934: if c_find_RZR_in_target%found then
7935: --
7936: --TEMPIK
7937: l_dt_rec_found := dt_api.check_min_max_dates
7938: (p_base_table_name => 'BEN_PSTL_ZIP_RNG_F',
7939: p_base_key_column => 'PSTL_ZIP_RNG_ID',
7940: p_base_key_value => l_new_value,
7941: p_from_date => l_min_esd,

Line 8724: l_dt_rec_found := dt_api.check_min_max_dates

8720: fetch c_find_RCL_in_target into l_new_value ;
8721: if c_find_RCL_in_target%found then
8722: --
8723: --TEMPIK
8724: l_dt_rec_found := dt_api.check_min_max_dates
8725: (p_base_table_name => 'BEN_RLTD_PER_CHG_CS_LER_F',
8726: p_base_key_column => 'RLTD_PER_CHG_CS_LER_ID',
8727: p_base_key_value => l_new_value,
8728: p_from_date => l_min_esd,

Line 9206: l_dt_rec_found := dt_api.check_min_max_dates

9202: fetch c_find_OPT_in_target into l_new_value ;
9203: if c_find_OPT_in_target%found then
9204: --
9205: --TEMPIK
9206: l_dt_rec_found := dt_api.check_min_max_dates
9207: (p_base_table_name => 'BEN_OPT_F',
9208: p_base_key_column => 'OPT_ID',
9209: p_base_key_value => l_new_value,
9210: p_from_date => l_min_esd,

Line 9803: l_dt_rec_found := dt_api.check_min_max_dates

9799: fetch c_find_LER_in_target into l_new_value ;
9800: --TEMPIK
9801: hr_utility.set_location('New value '||l_new_value,102);
9802: if l_new_value is not null then
9803: l_dt_rec_found := dt_api.check_min_max_dates
9804: (p_base_table_name => 'BEN_LER_F',
9805: p_base_key_column => 'LER_ID',
9806: p_base_key_value => l_new_value,
9807: p_from_date => l_min_esd,

Line 9822: l_dt_rec_found := dt_api.check_min_max_dates

9818: p_target_business_group_id, nvl(l_ler_id, -999) ) ;
9819: fetch c_find_LER_in_target into l_new_value ;
9820: --TEMPIK
9821: if l_new_value is not null then
9822: l_dt_rec_found := dt_api.check_min_max_dates
9823: (p_base_table_name => 'BEN_LER_F',
9824: p_base_key_column => 'LER_ID',
9825: p_base_key_value => l_new_value,
9826: p_from_date => l_min_esd,

Line 9848: l_dt_rec_found := dt_api.check_min_max_dates

9844: p_target_business_group_id, nvl(l_ler_id, -999)) ;
9845: fetch c_find_LER_TYP_in_target into l_new_value ;
9846: --TEMPIK
9847: if l_new_value is not null then
9848: l_dt_rec_found := dt_api.check_min_max_dates
9849: (p_base_table_name => 'BEN_LER_F',
9850: p_base_key_column => 'LER_ID',
9851: p_base_key_value => l_new_value,
9852: p_from_date => l_min_esd,

Line 10400: l_dt_rec_found := dt_api.check_min_max_dates

10396: fetch c_find_LPL_in_target into l_new_value ;
10397: if c_find_LPL_in_target%found then
10398: --
10399: --TEMPIK
10400: l_dt_rec_found := dt_api.check_min_max_dates
10401: (p_base_table_name => 'BEN_LER_PER_INFO_CS_LER_F',
10402: p_base_key_column => 'LER_PER_INFO_CS_LER_ID',
10403: p_base_key_value => l_new_value,
10404: p_from_date => l_min_esd,

Line 10836: l_dt_rec_found := dt_api.check_min_max_dates

10832: fetch c_find_ELP_in_target into l_new_value ;
10833: if c_find_ELP_in_target%found then
10834: --
10835: --TEMPIK
10836: l_dt_rec_found := dt_api.check_min_max_dates
10837: (p_base_table_name => 'BEN_ELIGY_PRFL_F',
10838: p_base_key_column => 'ELIGY_PRFL_ID',
10839: p_base_key_value => l_new_value,
10840: p_from_date => l_min_esd,

Line 11424: l_dt_rec_found := dt_api.check_min_max_dates

11420: fetch c_find_DCE_in_target into l_new_value ;
11421: if c_find_DCE_in_target%found then
11422: --
11423: --TEMPIK
11424: l_dt_rec_found := dt_api.check_min_max_dates
11425: (p_base_table_name => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
11426: p_base_key_column => 'DPNT_CVG_ELIGY_PRFL_ID',
11427: p_base_key_value => l_new_value,
11428: p_from_date => l_min_esd,

Line 12649: l_dt_rec_found := dt_api.check_min_max_dates

12645: --
12646: if c_find_PSL_in_target%found then
12647: --
12648: --TEMPIK
12649: l_dt_rec_found := dt_api.check_min_max_dates
12650: (p_base_table_name => 'BEN_PER_INFO_CHG_CS_LER_F',
12651: p_base_key_column => 'PER_INFO_CHG_CS_LER_ID',
12652: p_base_key_value => l_new_value,
12653: p_from_date => l_min_esd,

Line 13115: l_dt_rec_found := dt_api.check_min_max_dates

13111: fetch c_find_CCT_in_target into l_new_value ;
13112: if c_find_CCT_in_target%found then
13113: --
13114: --TEMPIK
13115: l_dt_rec_found := dt_api.check_min_max_dates
13116: (p_base_table_name => 'BEN_CM_TYP_F',
13117: p_base_key_column => 'CM_TYP_ID',
13118: p_base_key_value => l_new_value,
13119: p_from_date => l_min_esd,

Line 13594: l_dt_rec_found := dt_api.check_min_max_dates

13590: fetch c_find_PDL_in_target into l_new_value ;
13591: if c_find_PDL_in_target%found then
13592: --
13593: --TEMPIK
13594: l_dt_rec_found := dt_api.check_min_max_dates
13595: (p_base_table_name => 'BEN_PTD_LMT_F',
13596: p_base_key_column => 'PTD_LMT_ID',
13597: p_base_key_value => l_new_value,
13598: p_from_date => l_min_esd,

Line 14809: l_dt_rec_found := dt_api.check_min_max_dates

14805: fetch c_find_PLN_in_target into l_new_value ;
14806: if c_find_PLN_in_target%found then
14807: --
14808: --TEMPIK
14809: l_dt_rec_found := dt_api.check_min_max_dates
14810: (p_base_table_name => 'BEN_PL_F',
14811: p_base_key_column => 'PL_ID',
14812: p_base_key_value => l_new_value,
14813: p_from_date => l_min_esd,

Line 15690: l_dt_rec_found := dt_api.check_min_max_dates

15686: fetch c_find_SVA_in_target into l_new_value ;
15687: if c_find_SVA_in_target%found then
15688: --
15689: --TEMPIK
15690: l_dt_rec_found := dt_api.check_min_max_dates
15691: (p_base_table_name => 'BEN_SVC_AREA_F',
15692: p_base_key_column => 'SVC_AREA_ID',
15693: p_base_key_value => l_new_value,
15694: p_from_date => l_min_esd,

Line 16174: l_dt_rec_found := dt_api.check_min_max_dates

16170: fetch c_find_PON_in_target into l_new_value ;
16171: if c_find_PON_in_target%found then
16172: --
16173: --TEMPIK
16174: l_dt_rec_found := dt_api.check_min_max_dates
16175: (p_base_table_name => 'BEN_PL_TYP_OPT_TYP_F',
16176: p_base_key_column => 'PL_TYP_OPT_TYP_ID',
16177: p_base_key_value => l_new_value,
16178: p_from_date => l_min_esd,