DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on FND_USER

Line 22: | nmankodi 11-Apr-2005 fnd_user.customer_id column has been changed to

18: || Modified this object as per the FA110 PR Enh. ||
19: ||==============================================================================||
20: || pkpatel 07-OCT-2002 Bug No: 2600842 ||
21: || Added the parameter auth_resp_id in the call to THB igs_pe_pers_encumb_pkg
22: | nmankodi 11-Apr-2005 fnd_user.customer_id column has been changed to
23: | fnd_user.person_party_id as an ebizsuite wide TCA mandate.
24: ||==============================================================================||
25: */
26:

Line 23: | fnd_user.person_party_id as an ebizsuite wide TCA mandate.

19: ||==============================================================================||
20: || pkpatel 07-OCT-2002 Bug No: 2600842 ||
21: || Added the parameter auth_resp_id in the call to THB igs_pe_pers_encumb_pkg
22: | nmankodi 11-Apr-2005 fnd_user.customer_id column has been changed to
23: | fnd_user.person_party_id as an ebizsuite wide TCA mandate.
24: ||==============================================================================||
25: */
26:
27: FUNCTION IGS_PR_GET_SCSC_COMP(

Line 2575: fnd_user u

2571: v_spo_rec c_spo%ROWTYPE;
2572: CURSOR c_pe IS
2573: SELECT p.party_id person_id
2574: FROM hz_parties p,
2575: fnd_user u
2576: WHERE u.user_id = FND_GLOBAL.USER_ID
2577: AND u.person_party_id = p.party_id
2578: AND SUBSTR (igs_en_gen_003.get_staff_ind (p.party_id), 1, 1) = 'Y';
2579: CURSOR c_pen IS