APPS.IGF_SE_PAYMENT_PKG dependencies on IGF_LOOKUPS_VIEW

Line 259: cp_lookup_type igf_lookups_view.lookup_type%TYPE,

255: l_fund igf_aw_fund_mast_all.fund_id%TYPE;
256:
257: -- Get lookup meaning
258: CURSOR c_lookup(
259: cp_lookup_type igf_lookups_view.lookup_type%TYPE,
260: cp_lookup_code igf_lookups_view.lookup_code%TYPE
261: ) IS
262: SELECT 'x'
263: FROM igf_lookups_view

Line 260: cp_lookup_code igf_lookups_view.lookup_code%TYPE

256:
257: -- Get lookup meaning
258: CURSOR c_lookup(
259: cp_lookup_type igf_lookups_view.lookup_type%TYPE,
260: cp_lookup_code igf_lookups_view.lookup_code%TYPE
261: ) IS
262: SELECT 'x'
263: FROM igf_lookups_view
264: WHERE lookup_type = cp_lookup_type

Line 263: FROM igf_lookups_view

259: cp_lookup_type igf_lookups_view.lookup_type%TYPE,
260: cp_lookup_code igf_lookups_view.lookup_code%TYPE
261: ) IS
262: SELECT 'x'
263: FROM igf_lookups_view
264: WHERE lookup_type = cp_lookup_type
265: AND lookup_code = cp_lookup_code
266: AND enabled_flag = 'Y';
267: l_lookup c_lookup%ROWTYPE;

Line 473: FROM igf_lookups_view

469: CURSOR c_get_se_errors(
470: c_error_cd igf_se_payment_int.error_code%TYPE
471: ) IS
472: SELECT meaning
473: FROM igf_lookups_view
474: WHERE lookup_type = 'IGF_STUD_EMP_ERROR'
475: AND lookup_code = c_error_cd;
476:
477: payment_int_rec c_payment_int%ROWTYPE;

Line 489: l_error_meaming igf_lookups_view.meaning%TYPE;

485: x_program_application_id NUMBER;
486: x_program_update_date DATE;
487: l_status igf_se_payment_int.status%TYPE;
488: l_error igf_se_payment_int.error_code%TYPE;
489: l_error_meaming igf_lookups_view.meaning%TYPE;
490: my_exception EXCEPTION;
491:
492: BEGIN
493:

Line 823: FROM igf_lookups_view

819: CURSOR c_get_se_errors(
820: c_error_cd igf_se_payment_int.error_code%TYPE
821: ) IS
822: SELECT meaning
823: FROM igf_lookups_view
824: WHERE lookup_type = 'IGF_STUD_EMP_ERROR'
825: AND lookup_code = c_error_cd;
826:
827: x_last_update_date DATE ;

Line 836: l_error_meaming igf_lookups_view.meaning%TYPE;

832: x_program_application_id NUMBER;
833: x_program_update_date DATE;
834: l_status igf_se_payment_int.status%TYPE;
835: l_error igf_se_payment_int.error_code%TYPE;
836: l_error_meaming igf_lookups_view.meaning%TYPE;
837: my_exception EXCEPTION;
838:
839: CURSOR c_payment_int IS
840: SELECT rowid , spi.*