APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on DT_API

Line 474: l_dt_rec_found := dt_api.check_min_max_dates

470: fetch c_find_JRT_in_target into l_new_value ;
471: if c_find_JRT_in_target%found then
472: --
473: --TEMPIK
474: l_dt_rec_found := dt_api.check_min_max_dates
475: (p_base_table_name => 'BEN_JOB_RT_F',
476: p_base_key_column => 'JOB_RT_ID',
477: p_base_key_value => l_new_value,
478: p_from_date => l_min_esd,

Line 941: l_dt_rec_found := dt_api.check_min_max_dates

937: fetch c_find_HSR_in_target into l_new_value ;
938: if c_find_HSR_in_target%found then
939: --
940: --TEMPIK
941: l_dt_rec_found := dt_api.check_min_max_dates
942: (p_base_table_name => 'BEN_HRLY_SLRD_RT_F',
943: p_base_key_column => 'HRLY_SLRD_RT_ID',
944: p_base_key_value => l_new_value,
945: p_from_date => l_min_esd,

Line 1423: l_dt_rec_found := dt_api.check_min_max_dates

1419: fetch c_find_GRR_in_target into l_new_value ;
1420: if c_find_GRR_in_target%found then
1421: --
1422: --TEMPIK
1423: l_dt_rec_found := dt_api.check_min_max_dates
1424: (p_base_table_name => 'BEN_GRADE_RT_F',
1425: p_base_key_column => 'GRADE_RT_ID',
1426: p_base_key_value => l_new_value,
1427: p_from_date => l_min_esd,

Line 1892: l_dt_rec_found := dt_api.check_min_max_dates

1888: fetch c_find_FTR_in_target into l_new_value ;
1889: if c_find_FTR_in_target%found then
1890: --
1891: --TEMPIK
1892: l_dt_rec_found := dt_api.check_min_max_dates
1893: (p_base_table_name => 'BEN_FL_TM_PT_TM_RT_F',
1894: p_base_key_column => 'FL_TM_PT_TM_RT_ID',
1895: p_base_key_value => l_new_value,
1896: p_from_date => l_min_esd,

Line 2356: l_dt_rec_found := dt_api.check_min_max_dates

2352: fetch c_find_BUR_in_target into l_new_value ;
2353: if c_find_BUR_in_target%found then
2354: --
2355: --TEMPIK
2356: l_dt_rec_found := dt_api.check_min_max_dates
2357: (p_base_table_name => 'BEN_BRGNG_UNIT_RT_F',
2358: p_base_key_column => 'BRGNG_UNIT_RT_ID',
2359: p_base_key_value => l_new_value,
2360: p_from_date => l_min_esd,

Line 2836: l_dt_rec_found := dt_api.check_min_max_dates

2832: fetch c_find_ESR_in_target into l_new_value ;
2833: if c_find_ESR_in_target%found then
2834: --
2835: --TEMPIK
2836: l_dt_rec_found := dt_api.check_min_max_dates
2837: (p_base_table_name => 'BEN_EE_STAT_RT_F',
2838: p_base_key_column => 'EE_STAT_RT_ID',
2839: p_base_key_value => l_new_value,
2840: p_from_date => l_min_esd,

Line 3317: l_dt_rec_found := dt_api.check_min_max_dates

3313: fetch c_find_ASR_in_target into l_new_value ;
3314: if c_find_ASR_in_target%found then
3315: --
3316: --TEMPIK
3317: l_dt_rec_found := dt_api.check_min_max_dates
3318: (p_base_table_name => 'BEN_ASNT_SET_RT_F',
3319: p_base_key_column => 'ASNT_SET_RT_ID',
3320: p_base_key_value => l_new_value,
3321: p_from_date => l_min_esd,

Line 3786: l_dt_rec_found := dt_api.check_min_max_dates

3782: fetch c_find_TUR_in_target into l_new_value ;
3783: if c_find_TUR_in_target%found then
3784: --
3785: --TEMPIK
3786: l_dt_rec_found := dt_api.check_min_max_dates
3787: (p_base_table_name => 'BEN_TBCO_USE_RT_F',
3788: p_base_key_column => 'TBCO_USE_RT_ID',
3789: p_base_key_value => l_new_value,
3790: p_from_date => l_min_esd,

Line 4251: l_dt_rec_found := dt_api.check_min_max_dates

4247: fetch c_find_SAR_in_target into l_new_value ;
4248: if c_find_SAR_in_target%found then
4249: --
4250: --TEMPIK
4251: l_dt_rec_found := dt_api.check_min_max_dates
4252: (p_base_table_name => 'BEN_SVC_AREA_RT_F',
4253: p_base_key_column => 'SVC_AREA_RT_ID',
4254: p_base_key_value => l_new_value,
4255: p_from_date => l_min_esd,

Line 4729: l_dt_rec_found := dt_api.check_min_max_dates

4725: fetch c_find_QTR_in_target into l_new_value ;
4726: if c_find_QTR_in_target%found then
4727: --
4728: --TEMPIK
4729: l_dt_rec_found := dt_api.check_min_max_dates
4730: (p_base_table_name => 'BEN_QUAL_TITL_RT_F',
4731: p_base_key_column => 'QUAL_TITL_RT_ID',
4732: p_base_key_value => l_new_value,
4733: p_from_date => l_min_esd,

Line 5198: l_dt_rec_found := dt_api.check_min_max_dates

5194: fetch c_find_PZR_in_target into l_new_value ;
5195: if c_find_PZR_in_target%found then
5196: --
5197: --TEMPIK
5198: l_dt_rec_found := dt_api.check_min_max_dates
5199: (p_base_table_name => 'BEN_PSTL_ZIP_RT_F',
5200: p_base_key_column => 'PSTL_ZIP_RT_ID',
5201: p_base_key_value => l_new_value,
5202: p_from_date => l_min_esd,

Line 5678: l_dt_rec_found := dt_api.check_min_max_dates

5674: fetch c_find_PTR_in_target into l_new_value ;
5675: if c_find_PTR_in_target%found then
5676: --
5677: --TEMPIK
5678: l_dt_rec_found := dt_api.check_min_max_dates
5679: (p_base_table_name => 'BEN_PER_TYP_RT_F',
5680: p_base_key_column => 'PER_TYP_RT_ID',
5681: p_base_key_value => l_new_value,
5682: p_from_date => l_min_esd,

Line 6143: l_dt_rec_found := dt_api.check_min_max_dates

6139: fetch c_find_GNR_in_target into l_new_value ;
6140: if c_find_GNR_in_target%found then
6141: --
6142: --TEMPIK
6143: l_dt_rec_found := dt_api.check_min_max_dates
6144: (p_base_table_name => 'BEN_GNDR_RT_F',
6145: p_base_key_column => 'GNDR_RT_ID',
6146: p_base_key_value => l_new_value,
6147: p_from_date => l_min_esd,

Line 6608: l_dt_rec_found := dt_api.check_min_max_dates

6604: fetch c_find_DBR_in_target into l_new_value ;
6605: if c_find_DBR_in_target%found then
6606: --
6607: --TEMPIK
6608: l_dt_rec_found := dt_api.check_min_max_dates
6609: (p_base_table_name => 'BEN_DSBLD_RT_F',
6610: p_base_key_column => 'DSBLD_RT_ID',
6611: p_base_key_value => l_new_value,
6612: p_from_date => l_min_esd,

Line 7104: l_dt_rec_found := dt_api.check_min_max_dates

7100: fetch c_find_CTY_in_target into l_new_value ;
7101: if c_find_CTY_in_target%found then
7102: --
7103: --TEMPIK
7104: l_dt_rec_found := dt_api.check_min_max_dates
7105: (p_base_table_name => 'BEN_COMPTNCY_RT_F',
7106: p_base_key_column => 'COMPTNCY_RT_ID',
7107: p_base_key_value => l_new_value,
7108: p_from_date => l_min_esd,

Line 7566: l_dt_rec_found := dt_api.check_min_max_dates

7562: fetch c_find_LMM_in_target into l_new_value ;
7563: if c_find_LMM_in_target%found then
7564: --
7565: --TEMPIK
7566: l_dt_rec_found := dt_api.check_min_max_dates
7567: (p_base_table_name => 'BEN_LBR_MMBR_RT_F',
7568: p_base_key_column => 'LBR_MMBR_RT_ID',
7569: p_base_key_value => l_new_value,
7570: p_from_date => l_min_esd,

Line 8051: l_dt_rec_found := dt_api.check_min_max_dates

8047: fetch c_find_LAR_in_target into l_new_value ;
8048: if c_find_LAR_in_target%found then
8049: --
8050: --TEMPIK
8051: l_dt_rec_found := dt_api.check_min_max_dates
8052: (p_base_table_name => 'BEN_LOA_RSN_RT_F',
8053: p_base_key_column => 'LOA_RSN_RT_ID',
8054: p_base_key_value => l_new_value,
8055: p_from_date => l_min_esd,

Line 8532: l_dt_rec_found := dt_api.check_min_max_dates

8528: fetch c_find_OUR_in_target into l_new_value ;
8529: if c_find_OUR_in_target%found then
8530: --
8531: --TEMPIK
8532: l_dt_rec_found := dt_api.check_min_max_dates
8533: (p_base_table_name => 'BEN_ORG_UNIT_RT_F',
8534: p_base_key_column => 'ORG_UNIT_RT_ID',
8535: p_base_key_value => l_new_value,
8536: p_from_date => l_min_esd,

Line 9007: l_dt_rec_found := dt_api.check_min_max_dates

9003: fetch c_find_LER1_in_target into l_new_value ;
9004: if c_find_LER1_in_target%found then
9005: --
9006: --TEMPIK
9007: l_dt_rec_found := dt_api.check_min_max_dates
9008: (p_base_table_name => 'BEN_LGL_ENTY_RT_F',
9009: p_base_key_column => 'LGL_ENTY_RT_ID',
9010: p_base_key_value => l_new_value,
9011: p_from_date => l_min_esd,

Line 9481: l_dt_rec_found := dt_api.check_min_max_dates

9477: fetch c_find_PR__in_target into l_new_value ;
9478: if c_find_PR__in_target%found then
9479: --
9480: --TEMPIK
9481: l_dt_rec_found := dt_api.check_min_max_dates
9482: (p_base_table_name => 'BEN_PYRL_RT_F',
9483: p_base_key_column => 'PYRL_RT_ID',
9484: p_base_key_value => l_new_value,
9485: p_from_date => l_min_esd,

Line 9957: l_dt_rec_found := dt_api.check_min_max_dates

9953: fetch c_find_PBR_in_target into l_new_value ;
9954: if c_find_PBR_in_target%found then
9955: --
9956: --TEMPIK
9957: l_dt_rec_found := dt_api.check_min_max_dates
9958: (p_base_table_name => 'BEN_PY_BSS_RT_F',
9959: p_base_key_column => 'PY_BSS_RT_ID',
9960: p_base_key_value => l_new_value,
9961: p_from_date => l_min_esd,

Line 10428: l_dt_rec_found := dt_api.check_min_max_dates

10424: fetch c_find_CQR_in_target into l_new_value ;
10425: if c_find_CQR_in_target%found then
10426: --
10427: --TEMPIK
10428: l_dt_rec_found := dt_api.check_min_max_dates
10429: (p_base_table_name => 'BEN_CBR_QUALD_BNF_RT_F',
10430: p_base_key_column => 'CBR_QUALD_BNF_RT_ID',
10431: p_base_key_value => l_new_value,
10432: p_from_date => l_min_esd,

Line 10887: l_dt_rec_found := dt_api.check_min_max_dates

10883: if c_find_BRG_in_target%found then
10884: --
10885:
10886: --TEMPIK
10887: l_dt_rec_found := dt_api.check_min_max_dates
10888: (p_base_table_name => 'BEN_BENFTS_GRP_RT_F',
10889: p_base_key_column => 'BENFTS_GRP_RT_ID',
10890: p_base_key_value => l_new_value,
10891: p_from_date => l_min_esd,

Line 11343: l_dt_rec_found := dt_api.check_min_max_dates

11339: fetch c_find_CMR_in_target into l_new_value ;
11340: if c_find_CMR_in_target%found then
11341: --
11342: --TEMPIK
11343: l_dt_rec_found := dt_api.check_min_max_dates
11344: (p_base_table_name => 'BEN_CMBN_AGE_LOS_RT_F',
11345: p_base_key_column => 'CMBN_AGE_LOS_RT_ID',
11346: p_base_key_value => l_new_value,
11347: p_from_date => l_min_esd,

Line 11800: l_dt_rec_found := dt_api.check_min_max_dates

11796: fetch c_find_VMR_in_target into l_new_value ;
11797: if c_find_VMR_in_target%found then
11798: --
11799: --TEMPIK
11800: l_dt_rec_found := dt_api.check_min_max_dates
11801: (p_base_table_name => 'BEN_VRBL_MTCHG_RT_F',
11802: p_base_key_column => 'VRBL_MTCHG_RT_ID',
11803: p_base_key_value => l_new_value,
11804: p_from_date => l_min_esd,

Line 12280: l_dt_rec_found := dt_api.check_min_max_dates

12276: fetch c_find_PAP_in_target into l_new_value ;
12277: if c_find_PAP_in_target%found then
12278: --
12279: --TEMPIK
12280: l_dt_rec_found := dt_api.check_min_max_dates
12281: (p_base_table_name => 'BEN_PRTT_ANTHR_PL_RT_F',
12282: p_base_key_column => 'PRTT_ANTHR_PL_RT_ID',
12283: p_base_key_value => l_new_value,
12284: p_from_date => l_min_esd,

Line 12739: l_dt_rec_found := dt_api.check_min_max_dates

12735: fetch c_find_OPR_in_target into l_new_value ;
12736: if c_find_OPR_in_target%found then
12737: --
12738: --TEMPIK
12739: l_dt_rec_found := dt_api.check_min_max_dates
12740: (p_base_table_name => 'BEN_OTHR_PTIP_RT_F',
12741: p_base_key_column => 'OTHR_PTIP_RT_ID',
12742: p_base_key_value => l_new_value,
12743: p_from_date => l_min_esd,

Line 13198: l_dt_rec_found := dt_api.check_min_max_dates

13194: fetch c_find_NOC_in_target into l_new_value ;
13195: if c_find_NOC_in_target%found then
13196: --
13197: --TEMPIK
13198: l_dt_rec_found := dt_api.check_min_max_dates
13199: (p_base_table_name => 'BEN_NO_OTHR_CVG_RT_F',
13200: p_base_key_column => 'NO_OTHR_CVG_RT_ID',
13201: p_base_key_value => l_new_value,
13202: p_from_date => l_min_esd,

Line 13650: l_dt_rec_found := dt_api.check_min_max_dates

13646: fetch c_find_OMR_in_target into l_new_value ;
13647: if c_find_OMR_in_target%found then
13648: --
13649: --TEMPIK
13650: l_dt_rec_found := dt_api.check_min_max_dates
13651: (p_base_table_name => 'BEN_OPTD_MDCR_RT_F',
13652: p_base_key_column => 'OPTD_MDCR_RT_ID',
13653: p_base_key_value => l_new_value,
13654: p_from_date => l_min_esd,

Line 14107: l_dt_rec_found := dt_api.check_min_max_dates

14103: fetch c_find_EPM_in_target into l_new_value ;
14104: if c_find_EPM_in_target%found then
14105: --
14106: --TEMPIK
14107: l_dt_rec_found := dt_api.check_min_max_dates
14108: (p_base_table_name => 'BEN_ENRLD_ANTHR_PGM_RT_F',
14109: p_base_key_column => 'ENRLD_ANTHR_PGM_RT_ID',
14110: p_base_key_value => l_new_value,
14111: p_from_date => l_min_esd,

Line 14568: l_dt_rec_found := dt_api.check_min_max_dates

14564: fetch c_find_ENT_in_target into l_new_value ;
14565: if c_find_ENT_in_target%found then
14566: --
14567: --TEMPIK
14568: l_dt_rec_found := dt_api.check_min_max_dates
14569: (p_base_table_name => 'BEN_ENRLD_ANTHR_PTIP_RT_F',
14570: p_base_key_column => 'ENRLD_ANTHR_PTIP_RT_ID',
14571: p_base_key_value => l_new_value,
14572: p_from_date => l_min_esd,

Line 15031: l_dt_rec_found := dt_api.check_min_max_dates

15027: fetch c_find_ENL_in_target into l_new_value ;
15028: if c_find_ENL_in_target%found then
15029: --
15030: --TEMPIK
15031: l_dt_rec_found := dt_api.check_min_max_dates
15032: (p_base_table_name => 'BEN_ENRLD_ANTHR_PL_RT_F',
15033: p_base_key_column => 'ENRLD_ANTHR_PL_RT_ID',
15034: p_base_key_value => l_new_value,
15035: p_from_date => l_min_esd,

Line 15492: l_dt_rec_found := dt_api.check_min_max_dates

15488: fetch c_find_EAR_in_target into l_new_value ;
15489: if c_find_EAR_in_target%found then
15490: --
15491: --TEMPIK
15492: l_dt_rec_found := dt_api.check_min_max_dates
15493: (p_base_table_name => 'BEN_ENRLD_ANTHR_PLIP_RT_F',
15494: p_base_key_column => 'ENRLD_ANTHR_PLIP_RT_ID',
15495: p_base_key_value => l_new_value,
15496: p_from_date => l_min_esd,

Line 15953: l_dt_rec_found := dt_api.check_min_max_dates

15949: fetch c_find_EAO_in_target into l_new_value ;
15950: if c_find_EAO_in_target%found then
15951: --
15952: --TEMPIK
15953: l_dt_rec_found := dt_api.check_min_max_dates
15954: (p_base_table_name => 'BEN_ENRLD_ANTHR_OIPL_RT_F',
15955: p_base_key_column => 'ENRLD_ANTHR_OIPL_RT_ID',
15956: p_base_key_value => l_new_value,
15957: p_from_date => l_min_esd,

Line 16414: l_dt_rec_found := dt_api.check_min_max_dates

16410: fetch c_find_DOT_in_target into l_new_value ;
16411: if c_find_DOT_in_target%found then
16412: --
16413: --TEMPIK
16414: l_dt_rec_found := dt_api.check_min_max_dates
16415: (p_base_table_name => 'BEN_DPNT_OTHR_PTIP_RT_F',
16416: p_base_key_column => 'DPNT_OTHR_PTIP_RT_ID',
16417: p_base_key_value => l_new_value,
16418: p_from_date => l_min_esd,

Line 16873: l_dt_rec_found := dt_api.check_min_max_dates

16869: fetch c_find_DOP_in_target into l_new_value ;
16870: if c_find_DOP_in_target%found then
16871: --
16872: --TEMPIK
16873: l_dt_rec_found := dt_api.check_min_max_dates
16874: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',
16875: p_base_key_column => 'DPNT_CVRD_OTHR_PGM_RT_ID',
16876: p_base_key_value => l_new_value,
16877: p_from_date => l_min_esd,

Line 17336: l_dt_rec_found := dt_api.check_min_max_dates

17332: fetch c_find_DCP_in_target into l_new_value ;
17333: if c_find_DCP_in_target%found then
17334: --
17335: --TEMPIK
17336: l_dt_rec_found := dt_api.check_min_max_dates
17337: (p_base_table_name => 'BEN_DPNT_CVRD_PLIP_RT_F',
17338: p_base_key_column => 'DPNT_CVRD_PLIP_RT_ID',
17339: p_base_key_value => l_new_value,
17340: p_from_date => l_min_esd,

Line 17797: l_dt_rec_found := dt_api.check_min_max_dates

17793: fetch c_find_DCO_in_target into l_new_value ;
17794: if c_find_DCO_in_target%found then
17795: --
17796: --TEMPIK
17797: l_dt_rec_found := dt_api.check_min_max_dates
17798: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PTIP_RT_F',
17799: p_base_key_column => 'DPNT_CVRD_OTHR_PTIP_RT_ID',
17800: p_base_key_value => l_new_value,
17801: p_from_date => l_min_esd,

Line 18260: l_dt_rec_found := dt_api.check_min_max_dates

18256: fetch c_find_DCL_in_target into l_new_value ;
18257: if c_find_DCL_in_target%found then
18258: --
18259: --TEMPIK
18260: l_dt_rec_found := dt_api.check_min_max_dates
18261: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PL_RT_F',
18262: p_base_key_column => 'DPNT_CVRD_OTHR_PL_RT_ID',
18263: p_base_key_value => l_new_value,
18264: p_from_date => l_min_esd,

Line 18751: l_dt_rec_found := dt_api.check_min_max_dates

18747: fetch c_find_TTP_in_target into l_new_value ;
18748: if c_find_TTP_in_target%found then
18749: --
18750: --TEMPIK
18751: l_dt_rec_found := dt_api.check_min_max_dates
18752: (p_base_table_name => 'BEN_TTL_PRTT_RT_F',
18753: p_base_key_column => 'TTL_PRTT_RT_ID',
18754: p_base_key_value => l_new_value,
18755: p_from_date => l_min_esd,

Line 19249: l_dt_rec_found := dt_api.check_min_max_dates

19245: fetch c_find_TCV_in_target into l_new_value ;
19246: if c_find_TCV_in_target%found then
19247: --
19248: --TEMPIK
19249: l_dt_rec_found := dt_api.check_min_max_dates
19250: (p_base_table_name => 'BEN_TTL_CVG_VOL_RT_F',
19251: p_base_key_column => 'TTL_CVG_VOL_RT_ID',
19252: p_base_key_value => l_new_value,
19253: p_from_date => l_min_esd,

Line 19714: l_dt_rec_found := dt_api.check_min_max_dates

19710: p_target_business_group_id, nvl(l_vrbl_rt_prfl_rl_id, -999) ) ;
19711: fetch c_find_VPR_in_target into l_new_value ;
19712: if c_find_VPR_in_target%found then
19713: --TEMPIK
19714: l_dt_rec_found := dt_api.check_min_max_dates
19715: (p_base_table_name => 'BEN_VRBL_RT_PRFL_RL_F',
19716: p_base_key_column => 'VRBL_RT_PRFL_RL_ID',
19717: p_base_key_value => l_new_value,
19718: p_from_date => l_min_esd,

Line 20202: l_dt_rec_found := dt_api.check_min_max_dates

20198: fetch c_find_PRT_in_target into l_new_value ;
20199: if c_find_PRT_in_target%found then
20200: --
20201: --TEMPIK
20202: l_dt_rec_found := dt_api.check_min_max_dates
20203: (p_base_table_name => 'BEN_POE_RT_F',
20204: p_base_key_column => 'POE_RT_ID',
20205: p_base_key_value => l_new_value,
20206: p_from_date => l_min_esd,

Line 20673: l_dt_rec_found := dt_api.check_min_max_dates

20669: p_target_business_group_id, nvl(l_cntng_prtn_prfl_rt_id, -999) ) ;
20670: fetch c_find_CPN_in_target into l_new_value ;
20671: if c_find_CPN_in_target%found then
20672: --TEMPIK
20673: l_dt_rec_found := dt_api.check_min_max_dates
20674: (p_base_table_name => 'BEN_CNTNG_PRTN_PRFL_RT_F',
20675: p_base_key_column => 'CNTNG_PRTN_PRFL_RT_ID',
20676: p_base_key_value => l_new_value,
20677: p_from_date => l_min_esd,

Line 21161: l_dt_rec_found := dt_api.check_min_max_dates

21157: fetch c_find_PST_in_target into l_new_value ;
21158: if c_find_PST_in_target%found then
21159: --
21160: --TEMPIK
21161: l_dt_rec_found := dt_api.check_min_max_dates
21162: (p_base_table_name => 'BEN_PSTN_RT_F',
21163: p_base_key_column => 'PSTN_RT_ID',
21164: p_base_key_value => l_new_value,
21165: p_from_date => l_min_esd,

Line 21639: l_dt_rec_found := dt_api.check_min_max_dates

21635: fetch c_find_WLR_in_target into l_new_value ;
21636: if c_find_WLR_in_target%found then
21637: --
21638: --TEMPIK
21639: l_dt_rec_found := dt_api.check_min_max_dates
21640: (p_base_table_name => 'BEN_WK_LOC_RT_F',
21641: p_base_key_column => 'WK_LOC_RT_ID',
21642: p_base_key_value => l_new_value,
21643: p_from_date => l_min_esd,

Line 22104: l_dt_rec_found := dt_api.check_min_max_dates

22100: p_target_business_group_id, nvl(l_pct_fl_tm_rt_id, -999) ) ;
22101: fetch c_find_PFR_in_target into l_new_value ;
22102: if c_find_PFR_in_target%found then
22103: --TEMPIK
22104: l_dt_rec_found := dt_api.check_min_max_dates
22105: (p_base_table_name => 'BEN_PCT_FL_TM_RT_F',
22106: p_base_key_column => 'PCT_FL_TM_RT_ID',
22107: p_base_key_value => l_new_value,
22108: p_from_date => l_min_esd,

Line 22568: l_dt_rec_found := dt_api.check_min_max_dates

22564: fetch c_find_HWR_in_target into l_new_value ;
22565: if c_find_HWR_in_target%found then
22566: --
22567: --TEMPIK
22568: l_dt_rec_found := dt_api.check_min_max_dates
22569: (p_base_table_name => 'BEN_HRS_WKD_IN_PERD_RT_F',
22570: p_base_key_column => 'HRS_WKD_IN_PERD_RT_ID',
22571: p_base_key_value => l_new_value,
22572: p_from_date => l_min_esd,

Line 23033: l_dt_rec_found := dt_api.check_min_max_dates

23029: fetch c_find_CLR_in_target into l_new_value ;
23030: if c_find_CLR_in_target%found then
23031: --
23032: --TEMPIK
23033: l_dt_rec_found := dt_api.check_min_max_dates
23034: (p_base_table_name => 'BEN_COMP_LVL_RT_F',
23035: p_base_key_column => 'COMP_LVL_RT_ID',
23036: p_base_key_value => l_new_value,
23037: p_from_date => l_min_esd,

Line 23489: l_dt_rec_found := dt_api.check_min_max_dates

23485: fetch c_find_LSR_in_target into l_new_value ;
23486: if c_find_LSR_in_target%found then
23487: --
23488: --TEMPIK
23489: l_dt_rec_found := dt_api.check_min_max_dates
23490: (p_base_table_name => 'BEN_LOS_RT_F',
23491: p_base_key_column => 'LOS_RT_ID',
23492: p_base_key_value => l_new_value,
23493: p_from_date => l_min_esd,

Line 23945: l_dt_rec_found := dt_api.check_min_max_dates

23941: fetch c_find_LRN_in_target into l_new_value ;
23942: if c_find_LRN_in_target%found then
23943: --
23944: --TEMPIK
23945: l_dt_rec_found := dt_api.check_min_max_dates
23946: (p_base_table_name => 'BEN_LVG_RSN_RT_F',
23947: p_base_key_column => 'LVG_RSN_RT_ID',
23948: p_base_key_value => l_new_value,
23949: p_from_date => l_min_esd,

Line 24409: l_dt_rec_found := dt_api.check_min_max_dates

24405: fetch c_find_ART_in_target into l_new_value ;
24406: if c_find_ART_in_target%found then
24407: --
24408: --TEMPIK
24409: l_dt_rec_found := dt_api.check_min_max_dates
24410: (p_base_table_name => 'BEN_AGE_RT_F',
24411: p_base_key_column => 'AGE_RT_ID',
24412: p_base_key_value => l_new_value,
24413: p_from_date => l_min_esd,

Line 24909: l_dt_rec_found := dt_api.check_min_max_dates

24905: fetch c_find_SHR_in_target into l_new_value ;
24906: if c_find_SHR_in_target%found then
24907: --
24908: --TEMPIK
24909: l_dt_rec_found := dt_api.check_min_max_dates
24910: (p_base_table_name => 'BEN_SCHEDD_HRS_RT_F',
24911: p_base_key_column => 'SCHEDD_HRS_RT_ID',
24912: p_base_key_value => l_new_value,
24913: p_from_date => l_min_esd,

Line 25388: l_dt_rec_found := dt_api.check_min_max_dates

25384: fetch c_find_QIG_in_target into l_new_value ;
25385: if c_find_QIG_in_target%found then
25386: --
25387: --TEMPIK
25388: l_dt_rec_found := dt_api.check_min_max_dates
25389: (p_base_table_name => 'BEN_QUA_IN_GR_RT_F',
25390: p_base_key_column => 'QUA_IN_GR_RT_ID',
25391: p_base_key_value => l_new_value,
25392: p_from_date => l_min_esd,

Line 25857: l_dt_rec_found := dt_api.check_min_max_dates

25853: fetch c_find_PRR_in_target into l_new_value ;
25854: if c_find_PRR_in_target%found then
25855: --
25856: --TEMPIK
25857: l_dt_rec_found := dt_api.check_min_max_dates
25858: (p_base_table_name => 'BEN_PERF_RTNG_RT_F',
25859: p_base_key_column => 'PERF_RTNG_RT_ID',
25860: p_base_key_value => l_new_value,
25861: p_from_date => l_min_esd,

Line 26316: l_dt_rec_found := dt_api.check_min_max_dates

26312: fetch c_find_PGR_in_target into l_new_value ;
26313: if c_find_PGR_in_target%found then
26314: --
26315: --TEMPIK
26316: l_dt_rec_found := dt_api.check_min_max_dates
26317: (p_base_table_name => 'BEN_PPL_GRP_RT_F',
26318: p_base_key_column => 'PPL_GRP_RT_ID',
26319: p_base_key_value => l_new_value,
26320: p_from_date => l_min_esd,