DBA Data[Home] [Help]

APPS.AMS_TCOP_UTIL_PKG dependencies on HZ_PARTIES

Line 79: ,hz_parties hz

75: and not exists
76: (
77: select list2.party_id
78: from ams_list_entries list2
79: ,hz_parties hz
80: where list2.party_id=hz.party_id
81: and list2.list_header_id = p_list_header_id
82: and list2.list_entry_id=list1.list_entry_id
83: );

Line 121: -- refer to HZ_PARTIES.PARTY_ID

117: if (l_list_entry_id is not null) then
118: return 'N';
119: else
120: -- Check whether party_id mapped in AMS_LIST_ENTRIES
121: -- refer to HZ_PARTIES.PARTY_ID
122: -- if party_id columns is mapped to anything other than TCA Party Id
123: -- then fatigue rule will not be applicable.
124: open c_get_non_tca_map(l_list_header_id);
125: fetch c_get_non_tca_map