APPS.FUN_TRX_PVT dependencies on HZ_PARTIES

Line 55: SELECT PARTY_NAME INTO l_party_name from HZ_PARTIES

51: BEGIN
52:
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: SELECT PARTY_NAME INTO l_party_name from HZ_PARTIES
56: WHERE PARTY_ID = p_party_id;
57:
58: SELECT count(*) into l_assignment_count
59: FROM HZ_PARTIES HZP,

Line 59: FROM HZ_PARTIES HZP,

55: SELECT PARTY_NAME INTO l_party_name from HZ_PARTIES
56: WHERE PARTY_ID = p_party_id;
57:
58: SELECT count(*) into l_assignment_count
59: FROM HZ_PARTIES HZP,
60: HZ_PARTIES HZP2,
61: HZ_RELATIONSHIPS HZR,
62: HZ_ORG_CONTACTS HZC,
63: HZ_ORG_CONTACT_ROLES HZCR

Line 60: HZ_PARTIES HZP2,

56: WHERE PARTY_ID = p_party_id;
57:
58: SELECT count(*) into l_assignment_count
59: FROM HZ_PARTIES HZP,
60: HZ_PARTIES HZP2,
61: HZ_RELATIONSHIPS HZR,
62: HZ_ORG_CONTACTS HZC,
63: HZ_ORG_CONTACT_ROLES HZCR
64: WHERE HZR.RELATIONSHIP_CODE='CONTACT_OF'

Line 67: AND HZR.SUBJECT_TABLE_NAME='HZ_PARTIES'

63: HZ_ORG_CONTACT_ROLES HZCR
64: WHERE HZR.RELATIONSHIP_CODE='CONTACT_OF'
65: AND HZR.RELATIONSHIP_TYPE='CONTACT'
66: AND HZR.DIRECTIONAL_FLAG='F'
67: AND HZR.SUBJECT_TABLE_NAME='HZ_PARTIES'
68: AND HZR.OBJECT_TABLE_NAME='HZ_PARTIES'
69: AND HZR.SUBJECT_TYPE='PERSON'
70: AND HZR.OBJECT_ID=HZP2.PARTY_ID
71: AND HZR.SUBJECT_ID=HZP.PARTY_ID

Line 68: AND HZR.OBJECT_TABLE_NAME='HZ_PARTIES'

64: WHERE HZR.RELATIONSHIP_CODE='CONTACT_OF'
65: AND HZR.RELATIONSHIP_TYPE='CONTACT'
66: AND HZR.DIRECTIONAL_FLAG='F'
67: AND HZR.SUBJECT_TABLE_NAME='HZ_PARTIES'
68: AND HZR.OBJECT_TABLE_NAME='HZ_PARTIES'
69: AND HZR.SUBJECT_TYPE='PERSON'
70: AND HZR.OBJECT_ID=HZP2.PARTY_ID
71: AND HZR.SUBJECT_ID=HZP.PARTY_ID
72: AND HZR.OBJECT_ID = p_party_id

Line 274: FROM xle_firstparty_information_v le, hz_parties parties

270: l_le_end_dt DATE;
271:
272: CURSOR legal_entity_csr IS
273: SELECT le.le_effective_from, le.le_effective_to
274: FROM xle_firstparty_information_v le, hz_parties parties
275: WHERE parties.party_id = p_party_id
276: AND EXISTS (SELECT 1
277: FROM hz_party_usg_assignments hua
278: WHERE hua.party_id = parties.party_id

Line 2094: initiator_name HZ_PARTIES.PARTY_NAME%TYPE;

2090: l_count NUMBER;
2091: l_msg_data VARCHAR2(2000);
2092: l_success BOOLEAN;
2093: l_invoice_required VARCHAR2(1);
2094: initiator_name HZ_PARTIES.PARTY_NAME%TYPE;
2095: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;
2096:
2097: CURSOR ou_valid_csr IS
2098: SELECT count(*)

Line 2095: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;

2091: l_msg_data VARCHAR2(2000);
2092: l_success BOOLEAN;
2093: l_invoice_required VARCHAR2(1);
2094: initiator_name HZ_PARTIES.PARTY_NAME%TYPE;
2095: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;
2096:
2097: CURSOR ou_valid_csr IS
2098: SELECT count(*)
2099: FROM hr_operating_units ou

Line 2166: FROM hz_parties

2162: IF NOT l_success THEN
2163: -- Bug: 5291584
2164: SELECT party_name
2165: INTO initiator_name
2166: FROM hz_parties
2167: WHERE party_id=p_initiator_id;
2168:
2169: SELECT party_name
2170: INTO recipient_name

Line 2171: FROM hz_parties

2167: WHERE party_id=p_initiator_id;
2168:
2169: SELECT party_name
2170: INTO recipient_name
2171: FROM hz_parties
2172: WHERE party_id=p_recipient_id;
2173:
2174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2175: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CUSTOMER');