APPS.IGS_FI_GEN_GL dependencies on IGS_LOOKUP_VALUES

Line 141: FROM igs_lookup_values

137:
138: --Cursor to validate the accounting method param
139: CURSOR cur_acct_mth(cp_v_accounting_mthd IN igs_fi_control.accounting_method%TYPE) IS
140: SELECT lookup_code
141: FROM igs_lookup_values
142: WHERE lookup_code = cp_v_accounting_mthd
143: AND lookup_type = 'IGS_FI_ACCT_METHOD'
144: AND enabled_flag = 'Y'
145: AND trunc(sysdate) BETWEEN trunc(NVL(start_date_active, SYSDATE)) AND trunc(NVL(end_date_active, SYSDATE));

Line 465: FUNCTION get_lkp_meaning (p_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,

461: RETURN FALSE;
462:
463: END check_neg_chgadj_exists;
464:
465: FUNCTION get_lkp_meaning (p_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,
466: p_v_lookup_code IN igs_lookup_values.lookup_code%TYPE ) RETURN VARCHAR2 IS
467: /******************************************************************
468: Created By : sykrishn
469: Date Created By : 11-NOV-2002

Line 466: p_v_lookup_code IN igs_lookup_values.lookup_code%TYPE ) RETURN VARCHAR2 IS

462:
463: END check_neg_chgadj_exists;
464:
465: FUNCTION get_lkp_meaning (p_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,
466: p_v_lookup_code IN igs_lookup_values.lookup_code%TYPE ) RETURN VARCHAR2 IS
467: /******************************************************************
468: Created By : sykrishn
469: Date Created By : 11-NOV-2002
470: Purpose : Function Returns the meaning for the given lookup code

Line 480: CURSOR cur_lkp_meaning( cp_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,

476: Change History
477: Who When What
478: ******************************************************************/
479:
480: CURSOR cur_lkp_meaning( cp_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,
481: cp_v_lookup_code IN igs_lookup_values.lookup_code%TYPE )
482: IS
483: SELECT meaning
484: FROM igs_lookup_values

Line 481: cp_v_lookup_code IN igs_lookup_values.lookup_code%TYPE )

477: Who When What
478: ******************************************************************/
479:
480: CURSOR cur_lkp_meaning( cp_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,
481: cp_v_lookup_code IN igs_lookup_values.lookup_code%TYPE )
482: IS
483: SELECT meaning
484: FROM igs_lookup_values
485: WHERE lookup_code = cp_v_lookup_code

Line 484: FROM igs_lookup_values

480: CURSOR cur_lkp_meaning( cp_v_lookup_type IN igs_lookup_values.lookup_type%TYPE ,
481: cp_v_lookup_code IN igs_lookup_values.lookup_code%TYPE )
482: IS
483: SELECT meaning
484: FROM igs_lookup_values
485: WHERE lookup_code = cp_v_lookup_code
486: AND lookup_type = cp_v_lookup_type;
487:
488: l_v_meaning igs_lookup_values.meaning%TYPE;

Line 488: l_v_meaning igs_lookup_values.meaning%TYPE;

484: FROM igs_lookup_values
485: WHERE lookup_code = cp_v_lookup_code
486: AND lookup_type = cp_v_lookup_type;
487:
488: l_v_meaning igs_lookup_values.meaning%TYPE;
489:
490: BEGIN
491: IF p_v_lookup_code IS NULL THEN
492: RETURN NULL;