APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_ORG_CONTACTS

Line 2921: FROM hz_org_contacts org,

2917: CURSOR c_org_contact(in_org_contact_id in number,
2918: in_cust_account_id in number) IS
2919: SELECT role.cust_account_role_id,
2920: role.cust_acct_site_id
2921: FROM hz_org_contacts org,
2922: hz_relationships rel,
2923: hz_cust_accounts acct,
2924: hz_cust_account_roles role
2925: WHERE org.org_Contact_id = in_org_contact_id

Line 2947: FROM hz_org_contacts org,

2943: and status = 'A';
2944:
2945: CURSOR c_check_org_contact(in_party_id in number,in_org_contact_id in number) IS
2946: SELECT rel.party_id
2947: FROM hz_org_contacts org,
2948: hz_relationships rel
2949: WHERE org.org_contact_id = in_org_contact_id
2950: AND rel.status = 'A'
2951: AND rel.relationship_id = org.party_relationship_id

Line 5740: hz_org_contacts org_contact,

5736: IS
5737: SELECT org_contact.org_contact_id
5738: FROM hz_parties party,
5739: hz_relationships rel,
5740: hz_org_contacts org_contact,
5741: ar_lookups arl
5742: WHERE rel.object_id=in_party_id
5743: AND rel.relationship_id=org_contact.party_relationship_id
5744: AND rel.party_id=rel.subject_id