APPS.PAY_DK_BIK_UTILITY dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 24: l_value pay_user_column_instances_f.value%type;

20: return varchar2 is
21: l_effective_date date;
22: l_range_or_match pay_user_tables.range_or_match%type;
23: l_table_id pay_user_tables.user_table_id%type;
24: l_value pay_user_column_instances_f.value%type;
25: l_value_num NUMBER;
26:
27: begin
28: --

Line 72: from pay_user_column_instances_f CINST

68: if (l_range_or_match = 'M') then -- matched
69: begin
70: select CINST.value
71: into l_value
72: from pay_user_column_instances_f CINST
73: , pay_user_columns C
74: , pay_user_rows_f R
75: , pay_user_tables TAB
76: where TAB.user_table_id = l_table_id

Line 115: from pay_user_column_instances_f CINST

111: exception
112: when plsql_value_error then
113: select CINST.value
114: into l_value
115: from pay_user_column_instances_f CINST
116: , pay_user_columns C
117: , pay_user_rows_f R
118: , pay_user_tables TAB
119: where TAB.user_table_id = l_table_id

Line 164: from pay_user_column_instances_f CINST

160: else -- range
161: begin
162: select CINST.value
163: into l_value
164: from pay_user_column_instances_f CINST
165: , pay_user_columns C
166: , pay_user_rows_f R
167: , pay_user_tables TAB
168: where TAB.user_table_id = l_table_id