APPS.GHR_FEHB_PLAN_DESIGN dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 63: l_pt_name BEN_PER_INFO_CHG_CS_LER_F.name%type;

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;
67:

Line 64: l_source_table BEN_PER_INFO_CHG_CS_LER_F.source_table%type;

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;
67:
68:

Line 65: l_source_column BEN_PER_INFO_CHG_CS_LER_F.source_column%type;

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;
67:
68:
69: cursor c_get_ler_id is

Line 96: select name,per_info_chg_cs_ler_id from BEN_PER_INFO_CHG_CS_LER_F

92: and l_effective_date between
93: effective_start_date and effective_end_date;
94:
95: cursor c_chk_per_info_chg is
96: select name,per_info_chg_cs_ler_id from BEN_PER_INFO_CHG_CS_LER_F
97: where source_table = l_source_table
98: and source_column = l_source_column
99: and business_group_id = p_target_business_group_id;
100: