APPS.EAM_ISUP_CHECK_WO_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

         select count(pda.wip_entity_id)
         into l_count
         from
             po_distributions_all pda,
             wip_entities we
         where
           pda.po_header_id = p_header_id
           and pda.wip_entity_id = we.wip_entity_id
           and we.entity_type in (6,7);

Line: 63

         select count(pda.wip_entity_id)
         into l_count
         from
             po_distributions_all pda,
             wip_entities we
         where
           pda.po_release_id = p_release_id
           and pda.wip_entity_id = we.wip_entity_id
           and we.entity_type in (6,7);