PA Invoice Formats Listing

SELECT
        f.invoice_format_id invoice_format_id_header,
        f.name invoice_format_name,
        ig.name grouping,
        l.meaning invoice_format_type,
        f.start_date_active start_date,
        f.end_date_active end_date
FROM
        pa_lookups l,
        pa_invoice_groups ig,
        pa_invoice_formats f
WHERE
        ig.invoice_group_id = f.invoice_group_id
and     l.lookup_type = 'INVOICE FORMAT TYPE'
and     l.lookup_code = ig.invoice_format_type
and     f.invoice_format_id = nvl(:p_format,f.invoice_format_id)
and     f.invoice_group_id = nvl(:p_group,f.invoice_group_id)
ORDER BY
           l.meaning,f.name,ig.name