APPS.HRUSERDT dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 40: l_value pay_user_column_instances_f.value%type;

36: return varchar2 is
37: l_effective_date date;
38: l_range_or_match pay_user_tables.range_or_match%type;
39: l_table_id pay_user_tables.user_table_id%type;
40: l_value pay_user_column_instances_f.value%type;
41: begin
42: --
43: -- Use either the supplied date, or the date from fnd_sessions
44: --

Line 93: , pay_user_column_instances_f CINST

89: into l_value
90: from pay_user_tables TAB
91: , pay_user_columns C
92: , pay_user_rows_f R
93: , pay_user_column_instances_f CINST
94: where TAB.user_table_id = l_table_id
95: and C.user_table_id = TAB.user_table_id
96: and nvl (C.business_group_id,
97: p_bus_group_id) = p_bus_group_id

Line 140: , pay_user_column_instances_f CINST

136: into l_value
137: from pay_user_tables TAB
138: , pay_user_columns C
139: , pay_user_rows_f R
140: , pay_user_column_instances_f CINST
141: where TAB.user_table_id = l_table_id
142: and C.user_table_id = TAB.user_table_id
143: and nvl (C.business_group_id,
144: p_bus_group_id) = p_bus_group_id

Line 193: , pay_user_column_instances_f CINST

189: into l_value
190: from pay_user_tables TAB
191: , pay_user_columns C
192: , pay_user_rows_f R
193: , pay_user_column_instances_f CINST
194: where TAB.user_table_id = l_table_id
195: and C.user_table_id = TAB.user_table_id
196: and nvl (C.business_group_id,
197: p_bus_group_id) = p_bus_group_id