APPS.IGS_AZ_GEN_001 dependencies on IGS_AS_ORD_ITM_INT

Line 2439: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS

2435: l_person_id VARCHAR2 (30);
2436: --
2437: -- cursor to get the user_name corresponding to the person_id
2438: --
2439: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
2440: SELECT user_name
2441: FROM fnd_user
2442: WHERE person_party_id = cp_person_id;
2443: --