APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on FF_FORMULAS_F

Line 246: from ff_formulas_f

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

Line 738: from ff_formulas_f

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

Line 1087: ff_formulas_f_pkg.insert_row

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

Line 3490: from ff_formulas_f

3486: cursor csr_formulas_lock(p_formula_id in number) is
3487: select formula_id
3488: , rowid
3489: , effective_start_date
3490: from ff_formulas_f
3491: where formula_id = p_formula_id
3492: for update of formula_id;
3493: --
3494: cursor csr_balance_types_lock(p_balance_type_id in number) is

Line 4405: ff_formulas_f_pkg.delete_row

4401: --
4402: if l_formula_id is null or l_formula_id <> p_rowid_id_recs(i).id then
4403: l_formula_id := p_rowid_id_recs(i).id;
4404: --
4405: ff_formulas_f_pkg.delete_row
4406: (x_rowid => p_rowid_id_recs(i).rowid
4407: ,x_formula_id => l_formula_id
4408: ,x_dt_delete_mode => g_zap_deletion_mode
4409: ,x_validation_start_date => hr_api.g_sot