APPS.OE_CUSTOMER_INFO_PVT dependencies on HZ_PARTIES

Line 3206: FROM HZ_PARTIES

3202:
3203: IF p_party_id IS NOT NULL THEN
3204: SELECT OBJECT_VERSION_NUMBER
3205: into l_version_num
3206: FROM HZ_PARTIES
3207: WHERE party_id = p_party_id;
3208: END IF;
3209:
3210: RETURN l_version_num;

Line 3778: from HZ_PARTIES

3774:
3775: IF NVL(p_party_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
3776: select 'Y'
3777: into l_exists
3778: from HZ_PARTIES
3779: Where party_id = p_party_id;
3780:
3781: RETURN TRUE;
3782: END IF;

Line 3857: from hz_parties

3853: l_party_type VARCHAR2(50);
3854: BEGIN
3855: select party_type
3856: into l_party_type
3857: from hz_parties
3858: where party_id = p_party_id;
3859:
3860: RETURN l_party_type;
3861:

Line 3893: HZ_PARTIES PARTY,

3889:
3890: SELECT party.party_id,REL_PARTY.party_id
3891: into l_party_id , l_rel_party_id
3892: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
3893: HZ_PARTIES PARTY,
3894: HZ_CUST_ACCOUNTS ACCT,
3895: HZ_RELATIONSHIPS REL,
3896: HZ_ORG_CONTACTS ORG_CONT,
3897: HZ_PARTIES REL_PARTY

Line 3897: HZ_PARTIES REL_PARTY

3893: HZ_PARTIES PARTY,
3894: HZ_CUST_ACCOUNTS ACCT,
3895: HZ_RELATIONSHIPS REL,
3896: HZ_ORG_CONTACTS ORG_CONT,
3897: HZ_PARTIES REL_PARTY
3898: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3899: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3900: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3901: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 3901: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3897: HZ_PARTIES REL_PARTY
3898: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3899: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3900: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3901: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3902: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3903: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3904: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
3905: AND REL.OBJECT_ID = ACCT.PARTY_ID

Line 3902: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3898: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3899: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3900: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3901: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3902: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3903: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3904: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
3905: AND REL.OBJECT_ID = ACCT.PARTY_ID
3906: AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID