APPS.IGS_RE_WORKFLOW dependencies on FND_LOOKUPS

Line 2704: CURSOR c_status (l_lookup_code fnd_lookups.lookup_code%TYPE)IS

2700: SELECT full_name , person_number
2701: FROM igs_pe_person_base_v
2702: WHERE person_id = cp_person_id;
2703:
2704: CURSOR c_status (l_lookup_code fnd_lookups.lookup_code%TYPE)IS
2705: SELECT meaning
2706: FROM igs_lookups_view
2707: WHERE lookup_type = 'VS_EN_COURSE_ATMPT_STATUS'
2708: AND lookup_code = l_lookup_code ;

Line 2712: l_lookup fnd_lookups.lookup_code%TYPE;

2708: AND lookup_code = l_lookup_code ;
2709:
2710: l_c_person_info c_person_info%ROWTYPE;
2711: l_c_status c_status%ROWTYPE;
2712: l_lookup fnd_lookups.lookup_code%TYPE;
2713:
2714: BEGIN
2715:
2716: igs_re_workflow.create_adhoc_role( itemtype => itemtype ,