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 1053: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)

1049:
1050:
1051:
1052: /*-------------------------------------------------------------------------------------
1053: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)
1054: -------------------------------------------------------------------------------------*/
1055: FUNCTION GetUserName( p_user_id in Number)
1056: return Varchar2
1057: is

Line 1090: FROM hz_parties

1086: and (CURRENT_EMPLOYEE_FLAG = 'Y' or CURRENT_NPW_FLAG = 'Y'); /* Added OR condition for bug 7132968 */
1087: ELSIF (l_party_id > 0) THEN
1088: SELECT party_name
1089: INTO G_party_name
1090: FROM hz_parties
1091: WHERE party_id = l_party_id;
1092: END IF;
1093: /*Addition for bug 3729296 ends*/
1094:

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

1107:
1108: END GetUserName;
1109:
1110: /*-------------------------------------------------------------------------------------
1111: This function returns hz_parties.party_id for fnd_user.user_id (IN parameter)
1112: -------------------------------------------------------------------------------------*/
1113: FUNCTION GetPartyId( p_user_id in Number)
1114: return NUMBER
1115: is