find out which tables reference a table's primary key

[jack999]

how do you query data dictionary to find out which tables references a table's primary key as foreign key?

[slimdave]

dba_constraints

[bhallar]

select a.TABLE_NAME from user_constraints a , user_constraints b where a.constraint_name = b.R_CONSTRAINT_NAME and a.constraint_type in ('R','P');