APPS.IEX_DUNNING_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 417: ' hz_cust_site_uses_all site_uses, ' ||

413: l_custom_select := ' SELECT p.party_name ' ||
414: ' From hz_cust_acct_sites_all acct_sites, ' ||
415: ' hz_party_sites party_site, ' ||
416: ' hz_cust_accounts ca, ' ||
417: ' hz_cust_site_uses_all site_uses, ' ||
418: ' hz_parties p ' ||
419: ' WHERE acct_sites.cust_account_id = ca.cust_account_id ' ||
420: ' AND acct_sites.party_site_id = party_site.party_site_id ' ||
421: ' AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id ' ||

Line 430: ' hz_cust_site_uses_all site_uses, ' ||

426: l_custom_select := 'SELECT p.party_name ' ||
427: ' From hz_cust_acct_sites_all acct_sites, ' ||
428: ' hz_party_sites party_site, ' ||
429: ' hz_cust_accounts ca, ' ||
430: ' hz_cust_site_uses_all site_uses, ' ||
431: ' hz_parties p,' ||
432: ' iex_delinquencies_all delin ' ||
433: ' WHERE acct_sites.cust_account_id = ca.cust_account_id ' ||
434: ' AND acct_sites.party_site_id = party_site.party_site_id ' ||

Line 935: and exists (select 1 from hz_cust_site_uses_all site_uses where site_use_code = 'BILL_TO' and site_uses.site_use_id = customer_site_use_id)

931: -- Begin Bills Receivables
932: begin
933: select count(*) into t_cnt from iex_delinquencies , iex_dunning_plans_vl
934: where (status = DECODE(include_current,'Y','CURRENT','') or status in ('PREDELINQUENT','DELINQUENT'))
935: and exists (select 1 from hz_cust_site_uses_all site_uses where site_use_code = 'BILL_TO' and site_uses.site_use_id = customer_site_use_id)
936: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id;
937:
938: exception
939: when others then null;

Line 957: ' and exists (select 1 from hz_cust_site_uses_all site_uses where site_use_code = ''BILL_TO'' and site_uses.site_use_id = customer_site_use_id) ' ||

953: if t_cnt > 0 then
954: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
955: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||
956: ' where (status = DECODE(include_current,''Y'',''CURRENT'','' '') or status in (''PREDELINQUENT'',''DELINQUENT'')) ' || -- Bills Receivables
957: ' and exists (select 1 from hz_cust_site_uses_all site_uses where site_use_code = ''BILL_TO'' and site_uses.site_use_id = customer_site_use_id) ' ||
958: -- ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' || Bills Receivables
959: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||
960: ' order by ' || vSelectColumn;
961: else

Line 966: ' and exists (select 1 from hz_cust_site_uses_all site_uses where (site_use_code = ''DRAWEE'' or site_use_code = ''BILL_TO'') and site_uses.site_use_id = customer_site_use_id) ' ||

962: bug 16303059 end... */
963: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
964: ' FROM IEX_DELINQUENCIES , IEX_DUNNING_PLANS_VL '||
965: ' where (status = DECODE(include_current,''Y'',''CURRENT'','' '') or status in (''PREDELINQUENT'',''DELINQUENT'')) '|| -- Bills Receivables
966: ' and exists (select 1 from hz_cust_site_uses_all site_uses where (site_use_code = ''DRAWEE'' or site_use_code = ''BILL_TO'') and site_uses.site_use_id = customer_site_use_id) ' ||
967: ' and iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||
968: ' order by ' || vSelectColumn;
969: -- end if;
970: else