7: p_effective_date in date default null)
8: return varchar2 is
9: l_effective_date date;
10: l_range_or_match pay_user_tables.range_or_match%type;
11: l_value pay_user_column_instances_f.value%type;
12: cached boolean := FALSE;
13: g_leg_code varchar2(2);
14: begin
15: --
50: if (l_range_or_match = 'M') then -- matched
51: begin
52: select CINST.value
53: into l_value
54: from pay_user_column_instances_f CINST
55: , pay_user_columns C
56: , pay_user_rows_f R
57: , pay_user_tables TAB
58: where upper(TAB.user_table_name) = upper(p_table_name)
101: else -- range
102: begin
103: select CINST.value
104: into l_value
105: from pay_user_column_instances_f CINST
106: , pay_user_columns C
107: , pay_user_rows_f R
108: , pay_user_tables TAB
109: where upper(TAB.user_table_name) = upper(p_table_name)