APPS.HRUSERDT dependencies on PAY_USER_COLUMNS

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

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

Line 92: , pay_user_columns C

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

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

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

Line 139: , pay_user_columns C

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

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

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

Line 192: , pay_user_columns C

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