APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on FF_FORMULAS_F

Line 243: from ff_formulas_f

239: ,p_formula_type_id in number
240: ,p_formula in varchar2
241: ) is
242: select formula_id
243: from ff_formulas_f
244: where formula_type_id = p_formula_type_id
245: and upper(formula_name) = p_formula
246: and (p_effective_date between
247: effective_start_date and nvl(effective_end_date, hr_api.g_eot))

Line 735: from ff_formulas_f

731: l_count number;
732: --
733: cursor csr_sf_core_object_exists(p_core_object_id in number) is
734: select count(0)
735: from ff_formulas_f
736: where formula_id = p_core_object_id;
737: --
738: cursor csr_set_core_object_exists(p_core_object_id in number) is
739: select count(0)

Line 1084: ff_formulas_f_pkg.insert_row

1080: end if;
1081: --
1082: -- Insert the formula row.
1083: --
1084: ff_formulas_f_pkg.insert_row
1085: (x_rowid => l_rowid
1086: ,x_formula_id => l_formula_id
1087: ,x_effective_start_date => p_effective_date
1088: ,x_effective_end_date => hr_api.g_eot

Line 3472: from ff_formulas_f

3468: cursor csr_formulas_lock(p_formula_id in number) is
3469: select formula_id
3470: , rowid
3471: , effective_start_date
3472: from ff_formulas_f
3473: where formula_id = p_formula_id
3474: for update of formula_id;
3475: --
3476: cursor csr_balance_types_lock(p_balance_type_id in number) is

Line 4387: ff_formulas_f_pkg.delete_row

4383: --
4384: if l_formula_id is null or l_formula_id <> p_rowid_id_recs(i).id then
4385: l_formula_id := p_rowid_id_recs(i).id;
4386: --
4387: ff_formulas_f_pkg.delete_row
4388: (x_rowid => p_rowid_id_recs(i).rowid
4389: ,x_formula_id => l_formula_id
4390: ,x_dt_delete_mode => g_zap_deletion_mode
4391: ,x_validation_start_date => hr_api.g_sot