[Home] [Help]
359: cursor c_party (p_party_id number)
360: is
361: select
362: party_name
363: from hz_parties
364: where party_id = p_party_id;
365:
366: cursor c_account (p_cust_acct_id number)
367: is
367: is
368: select
369: p.party_name,
370: c.account_number
371: from hz_parties p,
372: hz_cust_accounts c
373: where c.cust_account_id = p_cust_acct_id
374: and c.party_id = p.party_id;
375:
378: select
379: p.party_name,
380: c.account_number,
381: site_uses.location
382: from hz_parties p,
383: hz_cust_accounts c,
384: hz_cust_acct_sites_all acct_sites,
385: hz_cust_site_uses_all site_uses
386: where site_uses.site_use_id = p_cust_site_use_id
394: p.party_name,
395: aps.trx_number TRANSACTION_NUMBER
396: from iex_delinquencies_all del,
397: ar_payment_schedules_all aps ,
398: hz_parties p
399: where del.delinquency_id = p_delinquency_id
400: and del.payment_Schedule_id = aps.payment_Schedule_id
401: and del.party_cust_id = p.party_id;
402:
877: dunn.delivery_status,
878: stytm.strategy_name strategy_name,
879: stry_temp_wkitem.name workitem_name
880: from iex_strategies iexst, iex_strategy_work_items wi,
881: hz_parties hzp, hz_cust_accounts acct, iex_dunnings dunn ,
882: iex_strategy_templates_vl stytm,
883: iex_stry_temp_work_items_vl stry_temp_wkitem
884: where wi.last_update_date>(sysdate-1)
885: and wi.strategy_id = iexst.strategy_id