eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 321: FROM xle_firstparty_information_v le, hz_parties parties

317: l_le_end_dt DATE;
318:
319: CURSOR legal_entity_csr IS
320: SELECT le.le_effective_from, le.le_effective_to
321: FROM xle_firstparty_information_v le, hz_parties parties
322: WHERE parties.party_id = p_party_id
323: AND EXISTS (SELECT 1
324: FROM hz_party_usg_assignments hua
325: WHERE hua.party_id = parties.party_id

Line 2206: initiator_name HZ_PARTIES.PARTY_NAME%TYPE;

2202: l_count NUMBER;
2203: l_msg_data VARCHAR2(2000);
2204: l_success BOOLEAN;
2205: l_invoice_required VARCHAR2(1);
2206: initiator_name HZ_PARTIES.PARTY_NAME%TYPE;
2207: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;
2208:
2209: CURSOR ou_valid_csr IS
2210: SELECT count(*)

Line 2207: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;

2203: l_msg_data VARCHAR2(2000);
2204: l_success BOOLEAN;
2205: l_invoice_required VARCHAR2(1);
2206: initiator_name HZ_PARTIES.PARTY_NAME%TYPE;
2207: recipient_name HZ_PARTIES.PARTY_NAME%TYPE;
2208:
2209: CURSOR ou_valid_csr IS
2210: SELECT count(*)
2211: FROM hr_operating_units ou

Line 2278: FROM hz_parties

2274: IF NOT l_success THEN
2275: -- Bug: 5291584
2276: SELECT party_name
2277: INTO initiator_name
2278: FROM hz_parties
2279: WHERE party_id=p_initiator_id;
2280:
2281: SELECT party_name
2282: INTO recipient_name

Line 2283: FROM hz_parties

2279: WHERE party_id=p_initiator_id;
2280:
2281: SELECT party_name
2282: INTO recipient_name
2283: FROM hz_parties
2284: WHERE party_id=p_recipient_id;
2285:
2286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CUSTOMER');