APPS.BEN_AGF_BUS dependencies on BEN_CMBN_AGE_LOS_FCTR

Line 1059: -- ben_cmbn_age_los_fctr table when the user deletes the record in the ben_

1055: -- -------------------------------------------------------------------------
1056: --
1057: -- Description
1058: -- This procedure is used to check that age factor records do not exist in the
1059: -- ben_cmbn_age_los_fctr table when the user deletes the record in the ben_
1060: -- age_fctr table.
1061: --
1062: -- Pre Conditions
1063: -- None.

Line 1083: from ben_cmbn_age_los_fctr cla

1079: l_proc varchar2(72):= g_package||'chk_child_records';
1080:
1081: --
1082: cursor chk_cmbn_age_los_fctr is select null
1083: from ben_cmbn_age_los_fctr cla
1084: where cla.age_fctr_id = p_age_fctr_id;
1085:
1086: begin
1087: --

Line 1090: -- check if age factor record exists in the ben_cmbn_age_los_fctr table

1086: begin
1087: --
1088: hr_utility.set_location('Entering:'||l_proc, 5);
1089: --
1090: -- check if age factor record exists in the ben_cmbn_age_los_fctr table
1091: --
1092: /* open chk_cmbn_age_los_fctr;
1093: --
1094: -- fetch value from cursor if it returns a record then the

Line 1112: (p_base_table_name => 'ben_cmbn_age_los_fctr',

1108: close chk_cmbn_age_los_fctr;*/ --Bug 2978945 used the common function rows_exist
1109: --
1110: --Bug 2978945
1111: If (ben_batch_utils.rows_exist
1112: (p_base_table_name => 'ben_cmbn_age_los_fctr',
1113: p_base_key_column => 'age_fctr_id',
1114: p_base_key_value => p_age_fctr_id
1115: )) Then
1116: ben_utility.child_exists_error('ben_cmbn_age_los_fctr');

Line 1116: ben_utility.child_exists_error('ben_cmbn_age_los_fctr');

1112: (p_base_table_name => 'ben_cmbn_age_los_fctr',
1113: p_base_key_column => 'age_fctr_id',
1114: p_base_key_value => p_age_fctr_id
1115: )) Then
1116: ben_utility.child_exists_error('ben_cmbn_age_los_fctr');
1117: End If;
1118:
1119: If (ben_batch_utils.rows_exist
1120: (p_base_table_name => 'ben_age_rt_f',