APPS.PAY_IVL_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 286: (p_base_table_name => 'pay_element_types_f'

282: );
283: --
284: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
285: NOT (dt_api.check_min_max_dates
286: (p_base_table_name => 'pay_element_types_f'
287: ,p_base_key_column => 'ELEMENT_TYPE_ID'
288: ,p_base_key_value => p_element_type_id
289:
290: ,p_from_date => p_validation_start_date

Line 880: from pay_element_types_f

876: cursor csr_ben_contri is
877: select contributions_used from
878: ben_benefit_classifications
879: where benefit_classification_id in ( select distinct benefit_classification_id
880: from pay_element_types_f
881: where element_type_id = p_element_type_id
882: and p_effective_date between effective_start_date
883: and effective_end_date);
884:

Line 1181: from pay_element_types_f

1177: cursor csr_classification is
1178: select non_payments_flag
1179: from pay_element_classifications
1180: where classification_id in ( select distinct classification_id
1181: from pay_element_types_f
1182: where element_type_id = p_element_type_id);
1183:
1184: l_boolean boolean;
1185: l_name pay_input_values_f.name%type := p_name;

Line 1252: from pay_element_types_f

1248: ) IS
1249: cursor csr_currency is
1250:
1251: select input_currency_code
1252: from pay_element_types_f
1253: where element_type_id = p_element_type_id;
1254:
1255: cursor csr_lookup is
1256: select 'X' from hr_lookups

Line 1908: from pay_element_types_f

1904:
1905: select contributions_used
1906: from ben_benefit_classifications
1907: where benefit_classification_id in ( select distinct benefit_classification_id
1908: from pay_element_types_f
1909: where element_type_id = p_element_type_id
1910: and p_effective_date between effective_start_date
1911: and effective_end_date);
1912: