TO FIND THE HOURS MIN AND SECOND IN ORACLE APPLICATIONS

/* Formatted on 2013/03/18 10:29 (Formatter Plus v4.8.8) */
SELECT    TO_CHAR (TRUNC (  (  (actual_completion_date - actual_start_date)
                             * 24
                             * 60
                             * 60
                            )
                          / 60
                          / 60
                         ),
                   '09'
                  )
       || 'hrs'
       || TO_CHAR (TRUNC (  MOD ((  (actual_completion_date
                                     - actual_start_date
                                    )
                                  * 24
                                  * 60
                                  * 60
                                 ),
                                 3600
                                )
                          / 60
                         ),
                   '09'
                  )
       || 'mins'
       || TO_CHAR (MOD (MOD ((  (actual_completion_date - actual_start_date)
                              * 24
                              * 60
                              * 60
                             ),
                             3600
                            ),
                        60
                       ),
                   '09'
                  )
       || 'secs' difference
  FROM fnd_concurrent_requests