DBA Data[Home] [Help]

APPS.IGF_SL_DL_PRINT_MANIFEST dependencies on IGF_AP_PERSON_V

Line 105: igf_ap_person_v per

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
109: WHERE lookup_type = DECODE(p_loan_catg,'DL_STAFFORD','IGF_SL_DL_STAFFORD','DL_PLUS','IGF_SL_DL_PLUS')