APPS.PAY_ETP_BUS_ND dependencies on FF_FORMULAS_F

Line 879: from ff_formulas_f fml, ff_formula_types ftp

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

Line 891: (p_base_table_name => 'FF_FORMULAS_F'

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

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

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

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;