-- This is my SQL query
SELECT   ref_desc, ref_code
    FROM REFERENCES
   WHERE ref_type = 'SALE_CAT' AND ref_code = :parameter.p_category
ORDER BY 2

DECLARE
   TEMP    NUMBER;
   rg_id   recordgroup;
BEGIN
   rg_id :=
      CREATE_GROUP_FROM_QUERY ('CGDV$DLRG',
                                  'SELECT REF_DESC, REF_CODE '
                               || 'FROM   REFERENCES '
                               || 'WHERE  REF_TYPE = ''SALE_CAT'' '
                               || 'AND    REF_CODE = '''
                               || :parameter.p_category
                               || ''' '
                               || 'ORDER BY  2'
                              );
   TEMP := POPULATE_GROUP (rg_id);
   POPULATE_LIST ('CTLBLK.CATEGORY', rg_id);
   DELETE_GROUP (rg_id);
END;

SELECT	GL_SHORT_DESC , GL_CODE
FROM	FM_GL_MASTER
WHERE	GL_TYPE IN ('CB')
AND     NVL(GL_STATUS,'Y')       = 'Y'
AND NVL(GL_COMP_CODE,:GLOBAL.COMPANY_CODE) = :GLOBAL.COMPANY_CODE
ORDER BY  2

select 'atul',1 from dual;