APPS.BEN_ECV_BUS dependencies on BEN_ELIGY_CRITERIA

Line 121: from ben_eligy_criteria

117: l_dummy varchar2(1);
118: --
119: Cursor csr_eligy_criteria_id is
120: select NULL
121: from ben_eligy_criteria
122: where eligy_criteria_id = p_eligy_criteria_id;
123: begin
124: --
125: hr_utility.set_location('Entering:'||l_proc, 5);

Line 435: from ben_eligy_criteria egl

431: --
432: cursor c_eligy_criteria is
433: select crit_col1_val_type_cd, crit_col1_datatype, col1_lookup_type, allow_range_validation_flag,
434: crit_col2_val_type_cd, crit_col2_datatype, col2_lookup_type, allow_range_validation_flag2
435: from ben_eligy_criteria egl
436: where egl.eligy_criteria_id = p_eligy_criteria_id
437: and egl.business_group_id = p_business_group_id;
438: -- Cursors for Set 1
439: cursor c_org_stru_ver is

Line 943: (p_base_table_name => 'ben_eligy_criteria',

939: p_argument_value => p_validation_end_date);
940: --
941: /* If ((nvl(p_eligy_criteria_id, hr_api.g_number) <> hr_api.g_number) and
942: NOT (dt_api.check_min_max_dates
943: (p_base_table_name => 'ben_eligy_criteria',
944: p_base_key_column => 'eligy_criteria_id',
945: p_base_key_value => p_eligy_criteria_id,
946: p_from_date => p_validation_start_date,
947: p_to_date => p_validation_end_date))) Then

Line 948: l_table_name := 'ben_eligy_criteria';

944: p_base_key_column => 'eligy_criteria_id',
945: p_base_key_value => p_eligy_criteria_id,
946: p_from_date => p_validation_start_date,
947: p_to_date => p_validation_end_date))) Then
948: l_table_name := 'ben_eligy_criteria';
949: Raise l_integrity_error;
950: End If;*/
951: --
952: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and