DBA Data[Home] [Help]

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 94: , pay_user_column_instances_f CINST

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

Line 141: , pay_user_column_instances_f CINST

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

Line 194: , pay_user_column_instances_f CINST

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