APPS.PAY_KR_BEE_UPLOAD dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 82: l_value pay_user_column_instances_f.value%type;

78: return varchar2 is
79: l_effective_date date;
80: l_range_or_match pay_user_tables.range_or_match%type;
81: l_table_id pay_user_tables.user_table_id%type;
82: l_value pay_user_column_instances_f.value%type;
83: l_row_low_range pay_user_rows_f.row_low_range_or_name%type;
84: l_row_high_range pay_user_rows_f.row_high_range%type;
85: l_leg_code varchar2(2);
86:

Line 107: from pay_user_column_instances_f CINST

103: and nvl(legislation_code, l_leg_code) = l_leg_code;
104:
105: cursor csr_get_row_value is
106: select decode(upper(p_low_high_range),'H',R.row_high_range,R.row_low_range_or_name)
107: from pay_user_column_instances_f CINST
108: , pay_user_columns C
109: , pay_user_rows_f R
110: , pay_user_tables TAB
111: where TAB.user_table_id = l_table_id