APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_LOOKUPS_VIEW

Line 2632: l_c_meaning igs_lookups_view.meaning%TYPE;

2628: Who When What
2629: ********************************************************************************************** */
2630:
2631: l_n_count NUMBER;
2632: l_c_meaning igs_lookups_view.meaning%TYPE;
2633:
2634: BEGIN
2635: l_c_meaning := null;
2636: -- If the message name is null, then return false

Line 2683: CURSOR c_meaning (cp_c_lkup_cd IN igs_lookups_view.lookup_code%TYPE,

2679: Change History (in reverse chronological order)
2680: Who When What
2681: ********************************************************************************************** */
2682:
2683: CURSOR c_meaning (cp_c_lkup_cd IN igs_lookups_view.lookup_code%TYPE,
2684: cp_c_lkup_type IN igs_lookups_view.lookup_type%TYPE) IS
2685: SELECT A.meaning
2686: FROM igs_lookups_view A
2687: WHERE A.lookup_code = cp_c_lkup_cd

Line 2684: cp_c_lkup_type IN igs_lookups_view.lookup_type%TYPE) IS

2680: Who When What
2681: ********************************************************************************************** */
2682:
2683: CURSOR c_meaning (cp_c_lkup_cd IN igs_lookups_view.lookup_code%TYPE,
2684: cp_c_lkup_type IN igs_lookups_view.lookup_type%TYPE) IS
2685: SELECT A.meaning
2686: FROM igs_lookups_view A
2687: WHERE A.lookup_code = cp_c_lkup_cd
2688: AND A.lookup_type = cp_c_lkup_type

Line 2686: FROM igs_lookups_view A

2682:
2683: CURSOR c_meaning (cp_c_lkup_cd IN igs_lookups_view.lookup_code%TYPE,
2684: cp_c_lkup_type IN igs_lookups_view.lookup_type%TYPE) IS
2685: SELECT A.meaning
2686: FROM igs_lookups_view A
2687: WHERE A.lookup_code = cp_c_lkup_cd
2688: AND A.lookup_type = cp_c_lkup_type
2689: AND A.enabled_flag = 'Y'
2690: AND TRUNC(SYSDATE) BETWEEN NVL(A.start_date_active,TRUNC(SYSDATE))

Line 2693: l_c_meaning igs_lookups_view.meaning%TYPE;

2689: AND A.enabled_flag = 'Y'
2690: AND TRUNC(SYSDATE) BETWEEN NVL(A.start_date_active,TRUNC(SYSDATE))
2691: AND NVL(A.end_date_active,TRUNC(SYSDATE)) ;
2692:
2693: l_c_meaning igs_lookups_view.meaning%TYPE;
2694:
2695: BEGIN
2696: OPEN c_meaning(p_c_lkup_cd,p_c_lkup_type);
2697: FETCH c_meaning INTO l_c_meaning;