DBA Data[Home] [Help]

APPS.CSD_PARTIES_UTIL dependencies on HZ_PARTIES

Line 58: AND owner_table_name = 'HZ_PARTIES'

54: SELECT contact_point_id,
55: last_update_date
56: FROM hz_contact_points
57: WHERE owner_table_id = l_party_id
58: AND owner_table_name = 'HZ_PARTIES'
59: AND contact_point_type='EMAIL'
60: AND primary_flag='Y' ;
61: BEGIN
62: -- Standard Start of API savepoint

Line 381: FROM HZ_PARTIES

377: l_api_version CONSTANT NUMBER := 1.0;
378: l_curr_party_id NUMBER := p_party_id;
379: CURSOR get_party_details IS
380: SELECT LAST_UPDATE_DATE
381: FROM HZ_PARTIES
382: WHERE PARTY_ID=l_curr_party_id;
383:
384: BEGIN
385: -- Standard Start of API savepoint