function B_Excel_linkFormatTrigger return boolean is

CURSOR c1 IS
    SELECT    company_name,
              a_number,
              a_start_date,
              current_status,
              city,
              comments
     FROM (
              SELECT p.company_name as company_name,
                     mf.a_seq_num AS a_number, 
                     mf.a_start_date AS a_start_date, 
                     mfasc.description AS current_status, 
                     mfaud.city AS city,
                     mfac.comments AS comments, 
                     mfac.comment_line_id, 
                     DENSE_RANK() OVER (PARTITION BY mf.a_seq_num ORDER BY mf.a_seq_num,mfac.comment_line_id DESC)  AS comment_rank
            
              FROM my_fields mf, 
                   my_fields_status_details mfasc, 
                   my_fields_asgn_act mfaa, 
                   my_fields_actors mfaud, 
                   my_fields_act_comments mfac,
                   props p
              
              WHERE         mf.my_fields_status_code = mfasc.my_fields_status_code
                           AND mf.a_seq_num = mfaa.a_seq_num
                           AND mfaa.my_fields_acts_seq_num = mfaud.my_fields_acts_seq_num  
                           AND mf.a_seq_num = mfac.a_seq_num
                           AND mf.p_seq_num = p.p_seq_num
                           AND p.p_seq_num <> 999999999
                           AND mf.my_fields_status_code NOT IN (199,155,160)
                           AND mfaa.main_actor_flag = 'Y'
                           AND (UPPER(mfaud.city) = UPPER(:pcity) OR UPPER(:pcity) = 'ALL')
                           AND (mfa.p_seq_num = :pp_seq_num OR :pp_seq_num = 1) 
     ) 
     WHERE comment_rank <6
     ORDER BY a_number


'
'
' (code to write the data into a csv file. )
'
'