Oracle Apps

  Users attached to Responsibilities and having Approval limits Null  select hou.name "Org name",        u.user_name "User Name",        u.description  "User Description",        u.start_date "User Start Date",        u.end_date "User End Date",        pe.full_name "Employee Name",    pe.person_id "Employee id",        pe.effective_start_date "Employee Start Date",        pe.effective_end_date "Employee End Date",        (SELECT name           FROM apps.per_all_positions pap          WHERE pap.position_id = pas.position_id) "Employee Position",          amount_limit "PR Approval Amount"   from apps.fnd_user u,        apps.fnd_user_resp_groups_direct furg,        apps.fnd_responsibility...