APPS.PAY_IVL_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 354: (p_base_table_name => 'pay_element_types_f'

350: );
351: --
352: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
353: NOT (dt_api.check_min_max_dates
354: (p_base_table_name => 'pay_element_types_f'
355: ,p_base_key_column => 'ELEMENT_TYPE_ID'
356: ,p_base_key_value => p_element_type_id
357:
358: ,p_from_date => p_validation_start_date

Line 948: from pay_element_types_f

944: cursor csr_ben_contri is
945: select contributions_used from
946: ben_benefit_classifications
947: where benefit_classification_id in ( select distinct benefit_classification_id
948: from pay_element_types_f
949: where element_type_id = p_element_type_id
950: and p_effective_date between effective_start_date
951: and effective_end_date);
952:

Line 1249: from pay_element_types_f

1245: cursor csr_classification is
1246: select non_payments_flag
1247: from pay_element_classifications
1248: where classification_id in ( select distinct classification_id
1249: from pay_element_types_f
1250: where element_type_id = p_element_type_id);
1251:
1252: l_boolean boolean;
1253: l_name pay_input_values_f.name%type := p_name;

Line 1320: from pay_element_types_f

1316: ) IS
1317: cursor csr_currency is
1318:
1319: select input_currency_code
1320: from pay_element_types_f
1321: where element_type_id = p_element_type_id;
1322:
1323: cursor csr_lookup is
1324: select 'X' from hr_lookups

Line 1399: from pay_element_types_f

1395: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1396: --
1397: cursor csr_currency(p_element_type_id number) is
1398: select input_currency_code
1399: from pay_element_types_f
1400: where element_type_id = p_element_type_id;
1401: --
1402: l_dummy varchar(1);
1403: l_proc varchar2(72) := g_package||'chk_default_value';

Line 1651: from pay_element_types_f

1647: IS
1648: --
1649: cursor csr_currency(p_element_type_id number) is
1650: select input_currency_code
1651: from pay_element_types_f
1652: where element_type_id = p_element_type_id;
1653: --
1654: l_proc varchar2(72) := g_package||'chk_max_min_value';
1655: l_range_check varchar2(10);

Line 2039: from pay_element_types_f

2035:
2036: select contributions_used
2037: from ben_benefit_classifications
2038: where benefit_classification_id in ( select distinct benefit_classification_id
2039: from pay_element_types_f
2040: where element_type_id = p_element_type_id
2041: and p_effective_date between effective_start_date
2042: and effective_end_date);
2043: