APPS.IGF_SL_CL_ORIG dependencies on IGF_LOOKUPS_VIEW

Line 371: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,

367: PROCEDURE cl_originate( errbuf OUT NOCOPY VARCHAR2,
368: retcode OUT NOCOPY NUMBER,
369: p_award_year IN VARCHAR2,
370: p_base_id IN VARCHAR2,
371: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
372: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
373: p_org_id IN NUMBER,
374: p_media_type IN VARCHAR2,
375: p_recipient_id IN VARCHAR2,

Line 407: l_lookup_type igf_lookups_view.lookup_type%TYPE;

403: lv_request_id NUMBER(10);
404: lv_request_status BOOLEAN;
405: l_i NUMBER(1);
406: l_alternate_code igs_ca_inst.alternate_code%TYPE;
407: l_lookup_type igf_lookups_view.lookup_type%TYPE;
408:
409: TYPE l_parameters IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
410: l_para_rec l_parameters;
411:

Line 419: p_lookup_type igf_lookups_view.lookup_type%TYPE,

415:
416: CURSOR cur_recip_dts(
417: p_loan_status igf_sl_loans.loan_status%TYPE,
418: p_active igf_sl_loans.active%TYPE,
419: p_lookup_type igf_lookups_view.lookup_type%TYPE,
420: p_enabled_flag igf_lookups_view.enabled_flag%TYPE,
421: p_recipient_id VARCHAR2
422: ) IS
423: SELECT DISTINCT lor.relationship_cd

Line 420: p_enabled_flag igf_lookups_view.enabled_flag%TYPE,

416: CURSOR cur_recip_dts(
417: p_loan_status igf_sl_loans.loan_status%TYPE,
418: p_active igf_sl_loans.active%TYPE,
419: p_lookup_type igf_lookups_view.lookup_type%TYPE,
420: p_enabled_flag igf_lookups_view.enabled_flag%TYPE,
421: p_recipient_id VARCHAR2
422: ) IS
423: SELECT DISTINCT lor.relationship_cd
424: FROM igf_ap_fa_base_rec fabase,

Line 446: FROM igf_lookups_view

442: AND lor.relationship_cd = recip.relationship_cd
443: AND lar.loan_number LIKE DECODE(p_loan_number,NULL,'%',p_loan_number)
444: AND substr(lar.loan_number, 1, 6) = substr(p_school_id,1,6)
445: AND fcat.fed_fund_code IN ( SELECT DISTINCT lookup_code
446: FROM igf_lookups_view
447: WHERE lookup_type = p_lookup_type
448: AND enabled_flag = p_enabled_flag)
449: ORDER BY
450: lor.relationship_cd;

Line 460: FROM igf_lookups_view

456:
457: CURSOR cur_get_parameters
458: IS
459: SELECT meaning
460: FROM igf_lookups_view
461: WHERE lookup_type = 'IGF_SL_CL_LOAN_CATG'
462: AND lookup_code = p_loan_catg
463: AND enabled_flag = 'Y'
464: UNION ALL

Line 466: FROM igf_lookups_view

462: AND lookup_code = p_loan_catg
463: AND enabled_flag = 'Y'
464: UNION ALL
465: SELECT meaning
466: FROM igf_lookups_view
467: WHERE lookup_type = 'IGF_GE_PARAMETERS'
468: AND lookup_code IN ('AWARD_YEAR','LOAN_CATG','LOAN_ID','PARAMETER_PASS')
469: AND enabled_flag = 'Y';
470:

Line 1203: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,

1199: retcode OUT NOCOPY NUMBER,
1200: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
1201: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1202: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
1203: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
1204: p_org_id IN NUMBER,
1205: p_relationship_cd IN VARCHAR2,
1206: p_media_type IN VARCHAR2,
1207: p_base_id IN VARCHAR2,

Line 1265: lv_source_name igf_lookups_view.meaning%TYPE;

1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
1262: lv_eft_authorization igf_sl_cl_setup.eft_authorization%TYPE;
1263: l_dummy_pell_efc NUMBER;
1264:
1265: lv_source_name igf_lookups_view.meaning%TYPE;
1266:
1267: lv_cl_version VARCHAR2(30);
1268:
1269: lv_s_foreign_postal_code igf_sl_lor_loc.s_foreign_postal_code%TYPE;

Line 1361: FROM igf_lookups_view

1357:
1358: CURSOR cur_get_school_name
1359: IS
1360: SELECT meaning
1361: FROM igf_lookups_view
1362: WHERE lookup_type = 'IGF_AP_SCHOOL_OPEID'
1363: AND lookup_code = p_school_id;
1364:
1365: -- To fetch the all the Disbursement dates,Amounts and Hold Rel Indicator