APPS.CSM_HZ_LOCATION_PKG dependencies on FND_USER

Line 108: FND_USER fnd

104: CURSOR c_get_party_id (c_user VARCHAR2)
105: IS
106: SELECT PERSON_PARTY_ID
107: FROM ASG_USER asg,
108: FND_USER fnd
109: WHERE asg.USER_NAME = c_user
110: AND fnd.USER_ID = asg.USER_ID;
111:
112: CURSOR c_req_hdr(b_uid VARCHAR2,tid number,lid number)

Line 110: AND fnd.USER_ID = asg.USER_ID;

106: SELECT PERSON_PARTY_ID
107: FROM ASG_USER asg,
108: FND_USER fnd
109: WHERE asg.USER_NAME = c_user
110: AND fnd.USER_ID = asg.USER_ID;
111:
112: CURSOR c_req_hdr(b_uid VARCHAR2,tid number,lid number)
113: IS
114: SELECT TASK_ASSIGNMENT_ID FROM CSM_REQ_HEADERS_INQ

Line 178: --Get the person party id for the user from fnd user.

174: x_return_status := FND_API.G_RET_STS_ERROR;
175: RETURN;
176: END IF;
177:
178: --Get the person party id for the user from fnd user.
179: OPEN c_get_party_id (p_record.CLID$$CS);
180: FETCH c_get_party_id INTO l_person_party_id;
181: CLOSE c_get_party_id ;
182: