DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on PAY_USER_COLUMNS

Line 141: FROM pay_user_columns cols

137: IS
138: SELECT pur.row_low_range_or_name
139: ,cols.user_column_name
140: ,inst.VALUE
141: FROM pay_user_columns cols
142: ,pay_user_rows_f pur
143: ,pay_user_column_instances_f inst
144: ,hr_lookups lookup
145: WHERE cols.user_table_id = p_table_id

Line 275: FROM pay_user_column_instances_f inst, pay_user_columns col

271: ,effective_start_date
272: )
273: + 1
274: ) cnt
275: FROM pay_user_column_instances_f inst, pay_user_columns col
276: WHERE col.user_table_id = p_table_id
277: AND inst.user_column_id = col.user_column_id
278: AND col.user_column_name LIKE p_column_name
279: AND ( p_value IS NULL

Line 311: FROM pay_user_columns col, pay_user_column_instances_f inst

307: ,p_value IN VARCHAR2
308: )
309: IS
310: SELECT inst.VALUE
311: FROM pay_user_columns col, pay_user_column_instances_f inst
312: WHERE col.user_table_id = p_table_id
313: AND col.user_column_name LIKE p_column_name
314: AND inst.user_column_id = col.user_column_id
315: AND ( p_value IS NULL OR inst.VALUE = p_value )