DBA Data[Home] [Help]

APPS.PV_OPPORTUNITY_VHUK dependencies on AS_PARTY_ADDRESSES_V

Line 899: as_party_addresses_v b,

895: -- --------------------------------------------------------------------------
896: CURSOR lc_address (pc_party_relation_id number) is
897: SELECT b.address_id, a.resource_id
898: FROM jtf_rs_resource_extns a,
899: as_party_addresses_v b,
900: pv_partner_profiles c
901: WHERE a.category = 'PARTNER'
902: AND sysdate between a.start_date_active and nvl(a.end_date_active,sysdate)
903: AND a.source_id = pc_party_relation_id