1233: , cv_business_group_id number
1234: , cv_effective_date date
1235: ) is
1236: select fff.formula_id
1237: from ff_formulas_f fff,
1238: ff_formulas_f fff1
1239: where fff.business_group_id = cv_business_group_id
1240: and cv_effective_date between fff.effective_start_date
1241: and fff.effective_end_date
1234: , cv_effective_date date
1235: ) is
1236: select fff.formula_id
1237: from ff_formulas_f fff,
1238: ff_formulas_f fff1
1239: where fff.business_group_id = cv_business_group_id
1240: and cv_effective_date between fff.effective_start_date
1241: and fff.effective_end_date
1242: and fff.formula_name = fff1.formula_name