APPS.PA_CONTROL_ITEMS_UTILS dependencies on HZ_PARTIES

Line 74: -- from hz_parties h

70: -- where user_id = p_resource_id;
71:
72: -- Cursor internal is
73: -- select h.party_id
74: -- from hz_parties h
75: -- where h.orig_system_reference = CONCAT('PER:',p_resource_id);
76:
77: -- l_party_id number;
78:

Line 1131: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)

1127:
1128:
1129:
1130: /*-------------------------------------------------------------------------------------
1131: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)
1132: -------------------------------------------------------------------------------------*/
1133: FUNCTION GetUserName( p_user_id in Number)
1134: return Varchar2
1135: is

Line 1162: FROM hz_parties

1158:
1159: IF (l_party_id > 0) THEN --If and ELSIF condtions interchanged for bug 8362886
1160: SELECT party_name
1161: INTO G_party_name
1162: FROM hz_parties
1163: WHERE party_id = l_party_id;
1164: ELSIF l_emp_id>0 THEN
1165: SELECT full_name
1166: INTO G_party_name

Line 1190: This function returns hz_parties.party_id for fnd_user.user_id (IN parameter)

1186:
1187: END GetUserName;
1188:
1189: /*-------------------------------------------------------------------------------------
1190: This function returns hz_parties.party_id for fnd_user.user_id (IN parameter)
1191: -------------------------------------------------------------------------------------*/
1192: FUNCTION GetPartyId( p_user_id in Number)
1193: return NUMBER
1194: is