DBA Data[Home] [Help]

APPS.IGS_AS_GR_WF_PKG dependencies on FND_USER

Line 30: CURSOR c_set_requestor (cp_requestor_id FND_USER.person_party_id%TYPE)

26: | has not set up in the system.
27: ===============================================================================================================+*/
28: IS
29:
30: CURSOR c_set_requestor (cp_requestor_id FND_USER.person_party_id%TYPE)
31: IS
32: SELECT
33: user_name
34: FROM

Line 35: fnd_user

31: IS
32: SELECT
33: user_name
34: FROM
35: fnd_user
36: WHERE
37: person_party_id = cp_requestor_id;
38:
39: CURSOR c_get_lead_instructor (cp_uoo_id IGS_EN_SU_ATTEMPT_ALL.UOO_ID%TYPE)

Line 46: fnd_user fu

42: pur.instructor_id instructor_id,
43: fu.user_name user_name
44: FROM
45: igs_ps_usec_tch_resp pur,
46: fnd_user fu
47: WHERE
48: fu.person_party_id = pur.instructor_id
49: AND
50: pur.lead_instructor_flag = 'Y'