DBA Data[Home] [Help]

APPS.PAY_USER_TABLE_DETAILS_PKG dependencies on PAY_USER_ROWS_F

Line 202: pay_user_rows_f pur,

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

Line 286: FROM pay_user_rows_f pur

282: INTO l_user_row_id
283: ,l_object_version_number
284: ,l_effective_start_date
285: ,l_effective_end_date
286: FROM pay_user_rows_f pur
287: -- bug 9234524 convert to user key units when matching
288: WHERE decode
289: (l_user_key_units,
290: 'D', to_char(fnd_date.canonical_to_date(X_ROW_LOW_RANGE_OR_NAME)),

Line 539: pay_user_rows_f pur,

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

Line 610: pay_user_rows_f pur,

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