APPS.IGS_EN_WORKFLOW dependencies on IGS_PS_USEC_TCH_RESP

Line 1680: FROM igs_ps_usec_tch_resp usec

1676: rec_uoo c_uoo%ROWTYPE;
1677:
1678: CURSOR c_usec_tch_resp (cp_n_uoo_id IN NUMBER) IS
1679: SELECT usec.instructor_id
1680: FROM igs_ps_usec_tch_resp usec
1681: WHERE usec.uoo_id = cp_n_uoo_id
1682: AND usec.lead_instructor_flag = 'Y';
1683:
1684: CURSOR c_person_number (cp_n_person_id IN NUMBER) IS

Line 1696: l_n_instuctor_id igs_ps_usec_tch_resp.instructor_id%TYPE;

1692: WHERE person_party_id = cp_n_person_id;
1693:
1694: l_t_temp NUMBER;
1695: l_c_person_num igs_pe_person_base_v.person_number%TYPE;
1696: l_n_instuctor_id igs_ps_usec_tch_resp.instructor_id%TYPE;
1697: l_c_user_name fnd_user.user_name%TYPE;
1698: l_c_perm_type VARCHAR2(2000);
1699:
1700: BEGIN