APPS.PAY_USER_TABLE_DETAILS_PKG dependencies on PAY_USER_COLUMNS

Line 203: pay_user_columns puc,

199: SELECT val.user_column_instance_id column_instance_id,
200: val.object_version_number object_version_number
201: FROM pay_user_tables put,
202: pay_user_rows_f pur,
203: pay_user_columns puc,
204: pay_user_column_instances_f val
205: WHERE val.user_row_id = pur.user_row_id
206: AND val.user_row_id = p_user_row_id
207: AND val.user_column_id = puc.user_column_id

Line 481: FROM pay_user_columns

477: SELECT user_column_id
478: ,object_version_number
479: INTO l_user_column_id
480: ,l_object_version_number
481: FROM pay_user_columns
482: WHERE user_column_name = X_USER_COLUMN_NAME
483: AND (
484: legislation_code = X_LEGISLATION_CODE
485: OR

Line 540: pay_user_columns puc

536: puc.user_column_id,
537: pur.effective_start_date
538: FROM pay_user_tables put,
539: pay_user_rows_f pur,
540: pay_user_columns puc
541: WHERE pur.user_table_id = put.user_table_id
542: AND puc.user_table_id = put.user_table_id
543: -- bug 9234524 convert to user key units when matching
544: AND decode

Line 611: pay_user_columns puc,

607: l_effective_start_date,
608: l_effective_end_date
609: FROM pay_user_tables put,
610: pay_user_rows_f pur,
611: pay_user_columns puc,
612: pay_user_column_instances_f val
613: WHERE val.user_row_id = pur.user_row_id
614: AND val.user_column_id = puc.user_column_id
615: AND pur.user_table_id = put.user_table_id