DBA Data[Home] [Help]

APPS.GHR_US_NFC_EXTRACTS dependencies on FF_FORMULAS_F

Line 5230: cursor csr_ff_type ( c_formula_type_id in ff_formulas_f.formula_id%type

5226: and b.data_elmt_typ_cd = 'R'
5227: and a.ext_rcd_id = c_ext_rcd_id
5228: order by a.seq_num;
5229:
5230: cursor csr_ff_type ( c_formula_type_id in ff_formulas_f.formula_id%type
5231: ,c_effective_date in date) is
5232: select formula_type_id
5233: from ff_formulas_f
5234: where formula_id = c_formula_type_id

Line 5233: from ff_formulas_f

5229:
5230: cursor csr_ff_type ( c_formula_type_id in ff_formulas_f.formula_id%type
5231: ,c_effective_date in date) is
5232: select formula_type_id
5233: from ff_formulas_f
5234: where formula_id = c_formula_type_id
5235: and c_effective_date between effective_start_date
5236: and effective_end_date;
5237: --

Line 5253: l_foumula_type_id ff_formulas_f.formula_id%type;

5249: and dfn.ext_dfn_id = c_ext_dfn_id;
5250: --
5251: l_ben_params csr_ben%rowtype;
5252: l_proc_name varchar2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
5253: l_foumula_type_id ff_formulas_f.formula_id%type;
5254: l_outputs ff_exec.outputs_t;
5255: l_ff_value ben_ext_rslt_dtl.val_01%type;
5256: l_ff_value_fmt ben_ext_rslt_dtl.val_01%type;
5257: l_max_len number;