Query to get open period details in Oracle Apps

SELECT
      distinct b.application_id,
      b.application_short_name,
      c.application_name,
      a.set_of_books_id,
      e.name set_of_books_name,
      e.short_name,
      a.period_name,
      a.start_date,
      a.end_date,
      a.closing_status ||' - '||d.meaning  period_status,
      a.year_start_date,
      a.quarter_num,
      a.quarter_start_date,
      a.period_year,
      a.period_num
FROM
      apps.gl_period_statuses a ,
      apps.fnd_application b,
      apps.fnd_application_tl c,
      apps.fnd_lookups d,
      apps.gl_sets_of_books e
WHERE
      a.application_id=b.application_id and
      a.application_id=c.application_id and
      a.closing_status=d.lookup_code and
      d.lookup_type='OKL_PERIOD_STATUS' and
      e.set_of_books_id=a.set_of_books_id and
      a.closing_status='O' and
      c.application_name like 'Payables';   -- Change the name of application

Get Request Set programs details with their exetuables

SELECT A.request_set_id,
  B.REQUEST_SET_STAGE_ID,
  A.USER_REQUEST_SET_NAME,
  C.USER_CONCURRENT_PROGRAM_NAME,
  E.EXECUTION_FILE_NAME,
  E.EXECUTION_METHOD_CODE
FROM apps.FND_REQUEST_SETS_TL A,
  apps.FND_REQUEST_SET_PROGRAMS B,
  apps.fnd_concurrent_programs_tl C,
  apps.fnd_concurrent_programs D,
  apps.fnd_executables E
WHERE a.request_set_id     =b.request_set_id
AND b.concurrent_program_id=c.concurrent_program_id
AND c.concurrent_program_id=d.concurrent_program_id
AND d.executable_id        =e.executable_id
AND (A.USER_REQUEST_SET_NAME) LIKE '%'   ||:RequestSetName   ||'%'
ORDER BY b.REQUEST_SET_STAGE_ID;