APPS.HRUSERDT dependencies on PAY_USER_COLUMNS

Line 84: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)

80: and nvl(legislation_code, g_leg_code) = g_leg_code;
81: --
82: if (l_range_or_match = 'M') then -- matched
83: begin
84: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
85: INDEX(R PAY_USER_ROWS_F_FK1)
86: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
87: ORDERED */
88: CINST.value

Line 91: , pay_user_columns C

87: ORDERED */
88: CINST.value
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

Line 131: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)

127: g_leg_code) = g_leg_code;
128: --
129: exception
130: when plsql_value_error then
131: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
132: INDEX(R PAY_USER_ROWS_F_FK1)
133: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
134: ORDERED */
135: CINST.value

Line 138: , pay_user_columns C

134: ORDERED */
135: CINST.value
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

Line 184: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)

180: return l_value;
181: --
182: else -- range
183: begin
184: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
185: INDEX(R PAY_USER_ROWS_F_FK1)
186: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
187: ORDERED */
188: CINST.value

Line 191: , pay_user_columns C

187: ORDERED */
188: CINST.value
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