APPS.BEN_CHECK_ORGANIZATION SQL Statements

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

Line: 5

          select '1' from ben_popl_org_f
           where organization_id = p_organization_id
	    and ( p_date_from  >  effective_start_date
                  or nvl(p_date_to, effective_end_date) < effective_end_date);

Line: 11

          select '1' from ben_popl_org_f
           where organization_id = p_organization_id;

Line: 15

             select '1' from ben_pl_bnf_f
              where organization_id = p_organization_id
	        and ( p_date_from  >  effective_start_date
                      or  nvl(p_date_to, effective_end_date) < effective_end_date);

Line: 21

          select '1' from ben_pl_bnf_f
           where organization_id = p_organization_id;