APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_PARTIES

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

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

Line 237: IF p_party_source_table = 'HZ_PARTIES' THEN

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

Line 241: FROM hz_parties

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

Line 418: IF (p_contact_source_table = 'HZ_PARTIES')

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

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

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

Line 1021: hz_parties hzp

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

Line 1075: (l_party_source_table = 'HZ_PARTIES'))

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