APPS.GHR_FEHB_PLAN_DESIGN dependencies on FF_FORMULAS_F

Line 61: l_ff_id ff_formulas_f.formula_id%type;

57: End Create_sub_life_events;
58:
59: Procedure create_person_type_usages (p_target_business_group_id in Number) is
60:
61: l_ff_id ff_formulas_f.formula_id%type;
62: l_formula_name ff_formulas_f.formula_name%type;
63: l_pt_name BEN_PER_INFO_CHG_CS_LER_F.name%type;
64: l_source_table BEN_PER_INFO_CHG_CS_LER_F.source_table%type;
65: l_source_column BEN_PER_INFO_CHG_CS_LER_F.source_column%type;

Line 62: l_formula_name ff_formulas_f.formula_name%type;

58:
59: Procedure create_person_type_usages (p_target_business_group_id in Number) is
60:
61: l_ff_id ff_formulas_f.formula_id%type;
62: l_formula_name ff_formulas_f.formula_name%type;
63: l_pt_name BEN_PER_INFO_CHG_CS_LER_F.name%type;
64: l_source_table BEN_PER_INFO_CHG_CS_LER_F.source_table%type;
65: l_source_column BEN_PER_INFO_CHG_CS_LER_F.source_column%type;
66: l_le_name BEN_LER_F.name%type;

Line 90: from ff_formulas_f

86:
87:
88: cursor c_get_ff_id is
89: select formula_id
90: from ff_formulas_f
91: where formula_name = l_formula_name
92: and l_effective_date between
93: effective_start_date and effective_end_date;
94: