DBA Data[Home] [Help]

APPS.PAY_USER_TABLE_DETAILS_PKG dependencies on PAY_USER_ROWS_F

Line 199: pay_user_rows_f pur,

195: IS
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

Line 258: FROM pay_user_rows_f

254: INTO l_user_row_id
255: ,l_object_version_number
256: ,l_effective_start_date
257: ,l_effective_end_date
258: FROM pay_user_rows_f
259: WHERE (
260: row_low_range_or_name = X_ROW_LOW_RANGE_OR_NAME
261: AND
262: NVL(row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')

Line 481: pay_user_rows_f pur,

477: SELECT pur.user_row_id,
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

Line 525: pay_user_rows_f pur,

521: l_object_version_number,
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