APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_PARTIES

Line 224: /* Description : Check if the Party Id exists in hz_parties */

220: END Is_Pty_Source_tab_Valid;
221:
222: /*-----------------------------------------------------------*/
223: /* Procedure name: Is_Party_Valid */
224: /* Description : Check if the Party Id exists in hz_parties */
225: /* po_vendors , employee depending on party_source_table */
226: /* value */
227: /*-----------------------------------------------------------*/
228:

Line 239: IF p_party_source_table = 'HZ_PARTIES' THEN

235:
236: l_dummy VARCHAR2(1);
237: l_return_value BOOLEAN := TRUE;
238: BEGIN
239: IF p_party_source_table = 'HZ_PARTIES' THEN
240:
241: SELECT 'x'
242: INTO l_dummy
243: FROM hz_parties

Line 243: FROM hz_parties

239: IF p_party_source_table = 'HZ_PARTIES' THEN
240:
241: SELECT 'x'
242: INTO l_dummy
243: FROM hz_parties
244: WHERE party_id = p_party_id;
245:
246: ELSIF p_party_source_table = 'PO_VENDORS' THEN
247: IF p_contact_flag = 'Y' THEN

Line 420: IF (p_contact_source_table = 'HZ_PARTIES')

416: CLOSE C1;
417: RETURN l_return_value;
418: END IF;
419:
420: IF (p_contact_source_table = 'HZ_PARTIES')
421: AND (l_party_source_table = 'HZ_PARTIES') THEN
422:
423: OPEN C2(p_contact_party_id,l_party_id);
424: FETCH C2 INTO l_dummy;

Line 421: AND (l_party_source_table = 'HZ_PARTIES') THEN

417: RETURN l_return_value;
418: END IF;
419:
420: IF (p_contact_source_table = 'HZ_PARTIES')
421: AND (l_party_source_table = 'HZ_PARTIES') THEN
422:
423: OPEN C2(p_contact_party_id,l_party_id);
424: FETCH C2 INTO l_dummy;
425: IF C2%NOTFOUND THEN

Line 1023: hz_parties hzp

1019: CURSOR C2(i_party_account_id NUMBER,
1020: i_party_id NUMBER) IS
1021: SELECT 'x'
1022: FROM hz_cust_accounts hzca,
1023: hz_parties hzp
1024: WHERE hzca.cust_account_id = i_party_account_id
1025: AND hzca.party_id = i_party_id
1026: AND hzca.party_id = hzp.party_id;
1027:

Line 1077: (l_party_source_table = 'HZ_PARTIES'))

1073: END IF;
1074: END IF;
1075:
1076: IF (--(p_relationship_type_code = 'OWNER') AND -- Need to check for all rel.
1077: (l_party_source_table = 'HZ_PARTIES'))
1078: THEN
1079: OPEN C2(p_party_account_id, l_party_id);
1080: FETCH C2 INTO l_dummy;
1081: IF c2%NOTFOUND