APPS.BEN_CLF_BUS dependencies on BEN_BATCH_UTILS

Line 1414: If (ben_batch_utils.rows_exist

1410: --
1411: hr_utility.set_location('Entering:'||l_proc, 5);
1412:
1413: --Used in Standard Rates
1414: If (ben_batch_utils.rows_exist
1415: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',
1416: p_base_key_column => 'comp_lvl_fctr_id',
1417: p_base_key_value => p_comp_lvl_fctr_id
1418: )) Then

Line 1423: If (ben_batch_utils.rows_exist

1419: ben_utility.child_exists_error('BEN_ACTY_BASE_RT_F');
1420: End If;
1421:
1422: --Used in Coverages Calculation Method
1423: If (ben_batch_utils.rows_exist
1424: (p_base_table_name => 'BEN_CVG_AMT_CALC_MTHD_F',
1425: p_base_key_column => 'comp_lvl_fctr_id',
1426: p_base_key_value => p_comp_lvl_fctr_id
1427: )) Then

Line 1432: If (ben_batch_utils.rows_exist

1428: ben_utility.child_exists_error('BEN_CVG_AMT_CALC_MTHD_F');
1429: End If;
1430:
1431: --Used in eligibility profiles
1432: If (ben_batch_utils.rows_exist
1433: (p_base_table_name => 'BEN_ELIG_COMP_LVL_PRTE_F',
1434: p_base_key_column => 'comp_lvl_fctr_id',
1435: p_base_key_value => p_comp_lvl_fctr_id
1436: )) Then

Line 1442: If (ben_batch_utils.rows_exist

1438: --Raise l_rows_exist;
1439: End If;
1440:
1441: --Used in variable rate profiles criteria
1442: If (ben_batch_utils.rows_exist
1443: (p_base_table_name => 'BEN_COMP_LVL_RT_F',
1444: p_base_key_column => 'comp_lvl_fctr_id',
1445: p_base_key_value => p_comp_lvl_fctr_id
1446: )) Then

Line 1451: If (ben_batch_utils.rows_exist

1447: ben_utility.child_exists_error('BEN_COMP_LVL_RT_F');
1448: End If;
1449:
1450: --Used in variable rate profiles
1451: If (ben_batch_utils.rows_exist
1452: (p_base_table_name => 'BEN_VRBL_RT_PRFL_F',
1453: p_base_key_column => 'comp_lvl_fctr_id',
1454: p_base_key_value => p_comp_lvl_fctr_id
1455: )) Then

Line 1460: If (ben_batch_utils.rows_exist

1456: ben_utility.child_exists_error('BEN_VRBL_RT_PRFL_F');
1457: End If;
1458:
1459: --Used in Period To Date limits
1460: If (ben_batch_utils.rows_exist
1461: (p_base_table_name => 'BEN_PTD_LMT_F',
1462: p_base_key_column => 'comp_lvl_fctr_id',
1463: p_base_key_value => p_comp_lvl_fctr_id
1464: )) Then

Line 1470: If (ben_batch_utils.rows_exist

1466: End If;
1467:
1468:
1469: --Used in Benefit Pools
1470: If (ben_batch_utils.rows_exist
1471: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
1472: p_base_key_column => 'comp_lvl_fctr_id',
1473: p_base_key_value => p_comp_lvl_fctr_id
1474: )) Then