[Home] [Help]
982: select a.party_id, a.party_type, a.party_name,
983: a.person_first_name, a.person_last_name,
984: b.cust_account_id, b.status, b.payment_schedule_id,
985: b.aging_bucket_line_id, b.customer_site_use_id
986: from iex_delinquencies_all b, hz_parties a
987: where a.party_id(+) = b.party_cust_id
988: and b.delinquency_id = p_delinquency_id;
989:
990: cursor c_get_party(p_work_item_id number) is
989:
990: cursor c_get_party(p_work_item_id number) is
991: select a.party_id, a.party_type, a.party_name,
992: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
993: from hz_parties a, iex_strategy_work_items w, iex_strategies s
994: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
995:
996: -- bug 4930376 ctlee sql id 14771930, use _all performance
997: cursor c_get_payment(p_delinquency_id number) is
1851: select a.party_id, a.party_type, a.party_name,
1852: a.person_first_name, a.person_last_name,
1853: b.cust_account_id, b.status, b.payment_schedule_id,
1854: b.aging_bucket_line_id, b.customer_site_use_id
1855: from iex_delinquencies_all b, hz_parties a
1856: where a.party_id(+) = b.party_cust_id
1857: and b.delinquency_id = p_delinquency_id;
1858:
1859: -- bug 4930376 ctlee sql id 14772154, use _all performance
1879:
1880: cursor c_get_party(p_work_item_id number) is
1881: select a.party_id, a.party_type, a.party_name,
1882: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
1883: from hz_parties a, iex_strategy_work_items w, iex_strategies s
1884: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
1885:
1886: l_strategy_level number ;
1887: l_DefaultStrategyLevel varchar2(20);