DBA Data[Home] [Help]

APPS.PER_FR_D2_PKG dependencies on FF_FORMULAS_F

Line 870: from ff_formulas_f

866: is
867: begin
868: select formula_id, effective_start_date
869: into p_formula_id, p_formula_start_date
870: from ff_formulas_f
871: where formula_name = 'USER_CONTRACT_PRORATED'
872: and business_group_id = nvl(p_business_group_id,-1)
873: and p_effective_date between effective_start_date and effective_end_date;
874: exception

Line 878: from ff_formulas_f

874: exception
875: when no_data_found then
876: select formula_id, effective_start_date
877: into p_formula_id, p_formula_start_date
878: from ff_formulas_f
879: where formula_name = 'TEMPLATE_CONTRACT_PRORATED'
880: and legislation_code = 'FR'
881: and p_effective_date between effective_start_date and effective_end_date;
882: end get_formula_ref;