APPS.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_ORIG_SYS_REFERENCES

Line 321: FROM HZ_ORIG_SYS_REFERENCES

317:
318: BEGIN
319: SELECT owner_table_id /* party_id would also do */
320: INTO l_party_id
321: FROM HZ_ORIG_SYS_REFERENCES
322: WHERE orig_system = p_person_rec.party_rec.orig_system
323: AND orig_system_reference = p_person_rec.party_rec.orig_system_reference
324: AND owner_table_name = 'HZ_PARTIES'
325: AND status = 'A';

Line 359: FROM HZ_ORIG_SYS_REFERENCES

355:
356: BEGIN
357: SELECT owner_table_id /* party_id would also do */
358: INTO l_party_id
359: FROM HZ_ORIG_SYS_REFERENCES
360: WHERE orig_system = p_organization_rec.party_rec.orig_system
361: AND orig_system_reference = p_organization_rec.party_rec.orig_system_reference
362: AND owner_table_name = 'HZ_PARTIES'
363: AND status = 'A';