DBA Data[Home] [Help]

APPS.EGO_DATA_SECURITY dependencies on HZ_PARTIES

Line 171: FROM hz_parties employee,

167: --PERF:Bug NO:6531906 --changed the query to look into the base tables instead of the View.
168: IF p_object_name IN ('EGO_ITEM','ENG_CHANGE') THEN
169: IF l_party_id IS NULL THEN
170: SELECT count(1) into l_count
171: FROM hz_parties employee,
172: FND_USER FND_user,
173: PER_ALL_PEOPLE_F HR_EMPLOYEE
174: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID
175: AND fnd_user.start_date <= SYSDATE

Line 188: FROM hz_parties employee ,

184: AND employee.party_id = HR_EMPLOYEE.PARTY_ID
185: AND user_name = p_user_name;
186: ELSE
187: SELECT Count(1) into l_count
188: FROM hz_parties employee ,
189: FND_USER FND_user ,
190: PER_ALL_PEOPLE_F HR_EMPLOYEE
191: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID
192: AND fnd_user.start_date <= SYSDATE

Line 3904: FROM hz_parties

3900: CURSOR get_user_grantee_key (cp_party_id NUMBER)
3901: IS
3902: --SELECT decode (party_type,'PERSON','HZ_PARTY:'||party_id,'GROUP','HZ_GROUP:'||party_id,'ORGANIZATION','HZ_COMPANY:'||party_id) grantee_key
3903: SELECT party_type
3904: FROM hz_parties
3905: WHERE party_id=cp_party_id;
3906:
3907: l_object_id number;
3908: p_user_name FND_GRANTS.grantee_key%TYPE;

Line 4391: FROM hz_parties

4387:
4388: CURSOR get_user_grantee_key (cp_party_id NUMBER) IS
4389: --SELECT decode (party_type,'PERSON','HZ_PARTY:'||party_id,'GROUP','HZ_GROUP:'||party_id,'ORGANIZATION','HZ_COMPANY:'||party_id) grantee_key
4390: SELECT party_type
4391: FROM hz_parties
4392: WHERE party_id=cp_party_id;
4393: l_object_id NUMBER;
4394: p_user_name FND_GRANTS.grantee_key%TYPE;
4395: l_party_type VARCHAR2(30);