DBA Data[Home] [Help]

APPS.FF_FORMULAS_F_PKG dependencies on PER_BUSINESS_GROUPS

Line 198: from per_business_groups

194: pet.business_group_id = p_formula_details.business_group_id
195: or p_formula_details.legislation_code =
196: (
197: select legislation_code
198: from per_business_groups
199: where business_group_id = pet.business_group_id
200: )
201: )
202: )

Line 884: , per_business_groups bg

880: , nvl(bg.legislation_code,ff.legislation_code)
881: , ff.effective_start_date
882: , ff.effective_end_date
883: from ff_formulas_f ff
884: , per_business_groups bg
885: where ff.formula_id = X_formula_id
886: and ff.business_group_id = bg.business_group_id (+)
887: and (
888: (X_Dt_Delete_Mode in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE')