DBA Data[Home] [Help]

APPS.MSC_X_UTIL dependencies on HZ_PARTIES

Line 8: -- name from HZ_PARTIES

4: STATUS_ERROR CONSTANT NUMBER := 1;
5: STATUS_SUCCESS CONSTANT NUMBER := 0;
6:
7: -- function get_party_name takes in party_id and returns the party
8: -- name from HZ_PARTIES
9: FUNCTION GET_PARTY_NAME (p_party_id IN NUMBER) RETURN VARCHAR2
10: IS
11: l_party_name VARCHAR2(30);
12:

Line 17: FROM hz_parties

13: BEGIN
14:
15: SELECT party_name
16: INTO l_party_name
17: FROM hz_parties
18: WHERE party_id = p_party_id;
19:
20: RETURN l_party_name;
21: