[Home] [Help]
100: per.api_person_id,
101: per.given_names,
102: per.surname,
103: per.middle_name
104: FROM igf_sl_lor_v lor,
105: igf_ap_person_v per
106: WHERE lor.pnote_status = 'S' /* Check for pnote_status 'Signed' */
107: AND lor.fed_fund_code IN (SELECT DISTINCT lookup_code
108: FROM igf_lookups_view