APPS.WIP_BIS_COMMON SQL Statements

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

Line: 35

   select count(assignment_id)
   from per_all_assignments_f
   where primary_flag = 'Y'
     and assignment_type = 'E'
     and trunc(p_date) between effective_start_date and effective_end_date
     and organization_id = p_organization_id;

Line: 51

		select PERIOD_START_DATE, SCHEDULE_CLOSE_DATE
		into   x_start_date, x_close_date
		from  org_acct_periods
		where ACCT_PERIOD_ID = p_acct_period_id
		and   ORGANIZATION_ID = p_organization_id ;

Line: 122

	select organization_name into x_organization
	from   org_organization_definitions
	where  organization_id = p_organization_id ;

Line: 137

        select target
          into x_target
          from bis_wipbiitorgprd_v
         where organization = p_organization_id
           and calendar = p_calendar
           and period_value = p_period_value;

Line: 144

        select target
          into x_target
	 from  bis_wipbipaorgprd_v
         where organization = p_organization_id
           and calendar = p_calendar
           and period_value = p_period_value;

Line: 151

        select target
          into x_target
          from bis_wipbiuzorgprd_v
         where organization = p_organization_id
           and calendar = p_calendar
           and period_value = p_period_value;

Line: 158

        select target
          into x_target
          from bis_wipbieforgprd_v
         where organization = p_organization_id
           and calendar = p_calendar
           and period_value = p_period_value;