APPS.IEX_STRATEGY_WORK_PUB dependencies on HZ_PARTIES

Line 759: from iex_delinquencies b, hz_parties a

755: select a.party_id, a.party_type, a.party_name,
756: a.person_first_name, a.person_last_name,
757: b.cust_account_id, b.status, b.payment_schedule_id,
758: b.aging_bucket_line_id, b.customer_site_use_id
759: from iex_delinquencies b, hz_parties a
760: where a.party_id(+) = b.party_cust_id
761: and b.delinquency_id = p_delinquency_id;
762:
763: cursor c_get_party(p_work_item_id number) is

Line 766: from hz_parties a, iex_strategy_work_items w, iex_strategies s

762:
763: cursor c_get_party(p_work_item_id number) is
764: select a.party_id, a.party_type, a.party_name,
765: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
766: from hz_parties a, iex_strategy_work_items w, iex_strategies s
767: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
768:
769: -- bug 4930376 ctlee sql id 14771930, use _all performance
770: cursor c_get_payment(p_delinquency_id number) is

Line 1607: from iex_delinquencies b, hz_parties a

1603: select a.party_id, a.party_type, a.party_name,
1604: a.person_first_name, a.person_last_name,
1605: b.cust_account_id, b.status, b.payment_schedule_id,
1606: b.aging_bucket_line_id, b.customer_site_use_id
1607: from iex_delinquencies b, hz_parties a
1608: where a.party_id(+) = b.party_cust_id
1609: and b.delinquency_id = p_delinquency_id;
1610:
1611: -- bug 4930376 ctlee sql id 14772154, use _all performance

Line 1635: from hz_parties a, iex_strategy_work_items w, iex_strategies s

1631:
1632: cursor c_get_party(p_work_item_id number) is
1633: select a.party_id, a.party_type, a.party_name,
1634: a.person_first_name, a.person_last_name, s.cust_account_id, s.customer_site_use_id
1635: from hz_parties a, iex_strategy_work_items w, iex_strategies s
1636: where a.party_id = s.party_id and s.strategy_id = w.strategy_id and w.work_item_id = p_work_item_id;
1637:
1638: l_strategy_level number ;
1639: l_DefaultStrategyLevel varchar2(20);