APPS.PAY_USER_TABLE_DETAILS_PKG dependencies on PAY_USER_COLUMNS

Line 200: pay_user_columns puc,

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

Line 423: FROM pay_user_columns

419: SELECT user_column_id
420: ,object_version_number
421: INTO l_user_column_id
422: ,l_object_version_number
423: FROM pay_user_columns
424: WHERE user_column_name = X_USER_COLUMN_NAME
425: AND (
426: legislation_code = X_LEGISLATION_CODE
427: OR

Line 482: pay_user_columns puc

478: puc.user_column_id,
479: pur.effective_start_date
480: FROM pay_user_tables put,
481: pay_user_rows_f pur,
482: pay_user_columns puc
483: WHERE pur.user_table_id = put.user_table_id
484: AND puc.user_table_id = put.user_table_id
485: AND pur.row_low_range_or_name = X_ROW_LOW_RANGE_OR_NAME
486: AND NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')

Line 526: pay_user_columns puc,

522: l_effective_start_date,
523: l_effective_end_date
524: FROM pay_user_tables put,
525: pay_user_rows_f pur,
526: pay_user_columns puc,
527: pay_user_column_instances_f val
528: WHERE val.user_row_id = pur.user_row_id
529: AND val.user_column_id = puc.user_column_id
530: AND pur.user_table_id = put.user_table_id