DBA Data[Home] [Help]

APPS.IGF_AW_LI_IMPORT dependencies on IGS_LOOKUPS_VIEW

Line 1738: CURSOR c_val_lookup_code(p_lookup_type igs_lookups_view.lookup_type%TYPE,

1734: AND award_number_txt = li_awd_rec.award_number_txt
1735: AND disbursement_num = p_disbursement_num;
1736: c_get_dact_fws_rec c_get_dact_fws%ROWTYPE;
1737:
1738: CURSOR c_val_lookup_code(p_lookup_type igs_lookups_view.lookup_type%TYPE,
1739: p_lookup_code igs_lookups_view.lookup_code%TYPE) IS
1740: SELECT meaning FROM igs_lookups_view WHERE lookup_type = p_lookup_type AND
1741: lookup_code = p_lookup_code and enabled_flag = 'Y';
1742: c_val_lookup_code_rec c_val_lookup_code%ROWTYPE;

Line 1739: p_lookup_code igs_lookups_view.lookup_code%TYPE) IS

1735: AND disbursement_num = p_disbursement_num;
1736: c_get_dact_fws_rec c_get_dact_fws%ROWTYPE;
1737:
1738: CURSOR c_val_lookup_code(p_lookup_type igs_lookups_view.lookup_type%TYPE,
1739: p_lookup_code igs_lookups_view.lookup_code%TYPE) IS
1740: SELECT meaning FROM igs_lookups_view WHERE lookup_type = p_lookup_type AND
1741: lookup_code = p_lookup_code and enabled_flag = 'Y';
1742: c_val_lookup_code_rec c_val_lookup_code%ROWTYPE;
1743:

Line 1740: SELECT meaning FROM igs_lookups_view WHERE lookup_type = p_lookup_type AND

1736: c_get_dact_fws_rec c_get_dact_fws%ROWTYPE;
1737:
1738: CURSOR c_val_lookup_code(p_lookup_type igs_lookups_view.lookup_type%TYPE,
1739: p_lookup_code igs_lookups_view.lookup_code%TYPE) IS
1740: SELECT meaning FROM igs_lookups_view WHERE lookup_type = p_lookup_type AND
1741: lookup_code = p_lookup_code and enabled_flag = 'Y';
1742: c_val_lookup_code_rec c_val_lookup_code%ROWTYPE;
1743:
1744: CURSOR c_get_disb_count IS