DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on CSD_PARTY_SITES_V

Line 612: FROM csd_party_sites_v ps

608: p_Site_Use_type IN VARCHAR2) IS
609:
610: CURSOR PS_Cur_Type(p_Party_ID NUMBER, p_Party_Site_Id NUMBER, p_Site_Use_type VARCHAR2) IS
611: SELECT ps.party_site_id
612: FROM csd_party_sites_v ps
613: WHERE ps.site_use_type = p_Site_Use_Type
614: AND ps.site_status = 'A'
615: AND ps.site_use_status = 'A'
616: AND ps.party_id = p_Party_Id

Line 620: FROM csd_party_sites_v ps

616: AND ps.party_id = p_Party_Id
617: AND ps.Party_Site_ID = p_Party_Site_ID
618: UNION ALL
619: SELECT ps.party_site_id
620: FROM csd_party_sites_v ps
621: WHERE ps.site_use_type = p_Site_Use_Type
622: AND ps.Party_Site_Id = p_Party_Site_ID
623: AND ps.site_status = 'A'
624: AND ps.site_use_status = 'A'