DBA Data[Home] [Help]

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_MANAGE_LIFE_EVENTS

Line 627: if ben_manage_life_events.fonm = 'Y' then

623:
624: --
625: -- FONM variables initialization
626: --
627: if ben_manage_life_events.fonm = 'Y' then
628: --
629: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
630: ben_manage_life_events.g_fonm_cvg_strt_dt);
631: --

Line 629: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

625: -- FONM variables initialization
626: --
627: if ben_manage_life_events.fonm = 'Y' then
628: --
629: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
630: ben_manage_life_events.g_fonm_cvg_strt_dt);
631: --
632: end if;
633: --

Line 630: ben_manage_life_events.g_fonm_cvg_strt_dt);

626: --
627: if ben_manage_life_events.fonm = 'Y' then
628: --
629: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
630: ben_manage_life_events.g_fonm_cvg_strt_dt);
631: --
632: end if;
633: --
634: l_coverage_value := p_bnft_amt;

Line 1185: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

1181: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1182: p_jurisdiction_code => l_jurisdiction_code,
1183: -- FONM
1184: p_param1 => 'BEN_IV_RT_STRT_DT',
1185: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1186: p_param2 => 'BEN_IV_CVG_STRT_DT',
1187: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1188: --
1189: p_val := l_outputs(l_outputs.first).value;

Line 1187: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1183: -- FONM
1184: p_param1 => 'BEN_IV_RT_STRT_DT',
1185: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1186: p_param2 => 'BEN_IV_CVG_STRT_DT',
1187: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1188: --
1189: p_val := l_outputs(l_outputs.first).value;
1190: --
1191: else

Line 1281: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

1277: p_acty_base_rt_id => p_acty_base_rt_id,
1278: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1279: p_jurisdiction_code => l_jurisdiction_code,
1280: p_param1 => 'BEN_IV_RT_STRT_DT',
1281: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1282: p_param2 => 'BEN_IV_CVG_STRT_DT',
1283: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1284: --
1285: if l_outputs(l_outputs.first).value is not null then

Line 1283: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1279: p_jurisdiction_code => l_jurisdiction_code,
1280: p_param1 => 'BEN_IV_RT_STRT_DT',
1281: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1282: p_param2 => 'BEN_IV_CVG_STRT_DT',
1283: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1284: --
1285: if l_outputs(l_outputs.first).value is not null then
1286: --
1287: p_val := l_outputs(l_outputs.first).value;

Line 1316: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

1312: p_ler_id => l_epe.ler_id,
1313: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1314: p_jurisdiction_code => l_jurisdiction_code,
1315: p_param1 => 'BEN_IV_RT_STRT_DT',
1316: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1317: p_param2 => 'BEN_IV_CVG_STRT_DT',
1318: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1319:
1320: if l_outputs(l_outputs.first).value is not null then

Line 1318: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1314: p_jurisdiction_code => l_jurisdiction_code,
1315: p_param1 => 'BEN_IV_RT_STRT_DT',
1316: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1317: p_param2 => 'BEN_IV_CVG_STRT_DT',
1318: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1319:
1320: if l_outputs(l_outputs.first).value is not null then
1321: p_val := l_outputs(l_outputs.first).value;
1322: end if;

Line 1346: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

1342: p_ler_id => l_epe.ler_id,
1343: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1344: p_jurisdiction_code => l_jurisdiction_code,
1345: p_param1 => 'BEN_IV_RT_STRT_DT',
1346: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1347: p_param2 => 'BEN_IV_CVG_STRT_DT',
1348: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1349:
1350: if l_outputs(l_outputs.first).value is not null then

Line 1348: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1344: p_jurisdiction_code => l_jurisdiction_code,
1345: p_param1 => 'BEN_IV_RT_STRT_DT',
1346: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1347: p_param2 => 'BEN_IV_CVG_STRT_DT',
1348: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1349:
1350: if l_outputs(l_outputs.first).value is not null then
1351: p_val := fnd_number.canonical_to_number(l_outputs(l_outputs.first).value);
1352: p_vrbl_rt_trtmt_cd := l_avrl.rt_trtmt_cd ;

Line 1379: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

1375: p_ler_id => l_epe.ler_id,
1376: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1377: p_jurisdiction_code => l_jurisdiction_code,
1378: p_param1 => 'BEN_IV_RT_STRT_DT',
1379: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1380: p_param2 => 'BEN_IV_CVG_STRT_DT',
1381: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1382: --
1383: if l_outputs(l_outputs.first).value is not null then

Line 1381: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));

1377: p_jurisdiction_code => l_jurisdiction_code,
1378: p_param1 => 'BEN_IV_RT_STRT_DT',
1379: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1380: p_param2 => 'BEN_IV_CVG_STRT_DT',
1381: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt));
1382: --
1383: if l_outputs(l_outputs.first).value is not null then
1384: --
1385: p_val := l_outputs(l_outputs.first).value;