APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on HZ_PARTIES

Line 219: ELSIF l_party_source_tbl = 'HZ_PARTIES' THEN

215: EXCEPTION
216: WHEN OTHERS THEN
217: NULL;
218: END;
219: ELSIF l_party_source_tbl = 'HZ_PARTIES' THEN
220: BEGIN
221: SELECT hz.party_number
222: ,cl.meaning --party_type
223: ,hz.party_name

Line 227: FROM hz_parties hz

223: ,hz.party_name
224: INTO x_party_header_tbl(i).party_number
225: ,x_party_header_tbl(i).party_type
226: ,l_pty_name
227: FROM hz_parties hz
228: ,csi_lookups cl
229: ,csi_item_instances cii
230: WHERE party_id = x_party_header_tbl(i).party_id
231: AND cl.lookup_type=l_pty_lookup_type

Line 468: IF ((p_party_tbl(l_party_row).party_source_table = 'HZ_PARTIES')

464: FOR l_party_row IN p_party_tbl.FIRST..p_party_tbl.LAST LOOP
465: IF p_party_tbl.EXISTS(l_party_row) -- Added for bug 3776650
466: THEN
467: -- Find out if one of the accounts for external parties is an owner account
468: IF ((p_party_tbl(l_party_row).party_source_table = 'HZ_PARTIES')
469: AND (p_party_tbl(l_party_row).party_id <> l_internal_party_id)
470: AND (p_party_tbl(l_party_row).relationship_type_code = 'OWNER')) THEN
471:
472: l_party_has_correct_acct := FALSE;

Line 972: AND (p_party_tbl(l_party_row).PARTY_SOURCE_TABLE = 'HZ_PARTIES')

968: IF ((p_party_tbl(l_party_row).PARTY_ID <> FND_API.G_MISS_NUM)
969: AND (p_party_tbl(l_party_row).PARTY_ID IS NOT NULL)
970: AND (p_party_tbl(l_party_row).party_id <> l_internal_party_id)
971: AND (p_party_tbl(l_party_row).PARTY_ID <> l_curr_party_rec.PARTY_ID)
972: AND (p_party_tbl(l_party_row).PARTY_SOURCE_TABLE = 'HZ_PARTIES')
973: AND (p_party_tbl(l_party_row).RELATIONSHIP_TYPE_CODE = l_curr_party_rec.RELATIONSHIP_TYPE_CODE )
974: AND (p_party_tbl(l_party_row).RELATIONSHIP_TYPE_CODE = 'OWNER'
975: ))
976: THEN