APPS.AR_TRANSFER_DOCUMENT dependencies on HZ_PARTY_SITES

Line 33: select 'x' from hz_party_sites where party_site_id = p_doc_rec.tp_source_id;

29: end;
30:
31: function validateTpSource(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is
32: cursor tp is
33: select 'x' from hz_party_sites where party_site_id = p_doc_rec.tp_source_id;
34: l_exists varchar2(1);
35: l_retcode boolean := false;
36: begin
37: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTpSource(+)'); end if;

Line 38: if p_doc_rec.tp_source_table = 'HZ_PARTY_SITES' then

34: l_exists varchar2(1);
35: l_retcode boolean := false;
36: begin
37: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTpSource(+)'); end if;
38: if p_doc_rec.tp_source_table = 'HZ_PARTY_SITES' then
39: open tp; fetch tp into l_exists; close tp;
40: if l_exists is null then l_retcode := false;
41: else l_retcode := true; end if;
42: else