APPS.PAY_ETP_BUS dependencies on FF_FORMULAS_F

Line 877: from ff_formulas_f fml, ff_formula_types ftp

873: l_exists varchar2(1);
874: Cursor c_chk_formula_type
875: is
876: select '1'
877: from ff_formulas_f fml, ff_formula_types ftp
878: where fml.formula_id = p_formula_id
879: and p_effective_date between fml.effective_start_date
880: and fml.effective_end_date
881: and ftp.formula_type_id = fml.formula_type_id

Line 889: (p_base_table_name => 'FF_FORMULAS_F'

885: hr_utility.set_location('Entering:'||l_proc, 5);
886: --
887: If p_formula_id is not null Then
888: If not (dt_api.rows_exist
889: (p_base_table_name => 'FF_FORMULAS_F'
890: ,p_base_key_column => 'FORMULA_ID'
891: ,p_base_key_value => p_formula_id
892: ,p_from_date => p_validation_start_date
893: ,p_to_date => p_validation_end_date

Line 898: fnd_message.set_token('TABLE','FF_FORMULAS_F');

894: )) Then
895: --
896: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
897: fnd_message.set_token('COLUMN','FORMULA_ID');
898: fnd_message.set_token('TABLE','FF_FORMULAS_F');
899: fnd_message.raise_error;
900: --
901: End If;
902: --

Line 2041: from ff_formula_types ftp, ff_formulas_f fml

2037:
2038: Cursor c_formula_type
2039: is
2040: select formula_type_name
2041: from ff_formula_types ftp, ff_formulas_f fml
2042: where fml.formula_id = p_iterative_formula_id
2043: and p_effective_date between fml.effective_start_date
2044: and fml.effective_end_date
2045: and ftp.formula_type_id = fml.formula_type_id;

Line 2052: (p_base_table_name => 'FF_FORMULAS_F'

2048: hr_utility.set_location('Entering:'||l_proc, 5);
2049: --
2050: If nvl(p_iterative_formula_id,hr_api.g_number) <> hr_api.g_number Then
2051: If not (dt_api.rows_exist
2052: (p_base_table_name => 'FF_FORMULAS_F'
2053: ,p_base_key_column => 'FORMULA_ID'
2054: ,p_base_key_value => p_iterative_formula_id
2055: ,p_from_date => p_validation_start_date
2056: ,p_to_date => p_validation_end_date

Line 2061: fnd_message.set_token('TABLE','FF_FORMULAS_F');

2057: )) Then
2058: --
2059: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2060: fnd_message.set_token('COLUMN','FORMULA_ID');
2061: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2062: fnd_message.raise_error;
2063: --
2064: End If;
2065: End If;

Line 2190: (p_base_table_name => 'FF_FORMULAS_F'

2186: End If;
2187: --
2188: If nvl(p_proration_formula_id,hr_api.g_number) <> hr_api.g_number Then
2189: If not (dt_api.rows_exist
2190: (p_base_table_name => 'FF_FORMULAS_F'
2191: ,p_base_key_column => 'FORMULA_ID'
2192: ,p_base_key_value => p_proration_formula_id
2193: ,p_from_date => p_validation_start_date
2194: ,p_to_date => p_validation_end_date

Line 2199: fnd_message.set_token('TABLE','FF_FORMULAS_F');

2195: )) Then
2196: --
2197: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2198: fnd_message.set_token('COLUMN','PRORATION_FORMULA_ID');
2199: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2200: fnd_message.raise_error;
2201: --
2202: End If;
2203: End If;