APPS.JL_BR_WORKDAY_CALENDAR SQL Statements

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

Line: 31

	select	to_date(p_date,'DD-MM-YYYY')
	into	x_date
	from	dual;

Line: 49

	          SELECT  a.local_holiday_type, b.disable_date
                    INTO  x_type, x_disable_date
	            FROM  jl_br_local_holiday_dates a,
		          jl_br_local_holiday_sets b
                   WHERE  b.local_holiday_set_name = p_city  -- Bug 801019
  	             AND  a.local_holiday_set_id   = b.local_holiday_set_id
  	             AND  a.local_holiday_date     = x_date
                     AND  nvl(b.disable_date,sysdate + 1) > sysdate;

Line: 83

	    SELECT  seq_num,	prior_date,	next_date
	      INTO  x_seq_num,      x_prior_date,   x_next_date
	      FROM  BOM_CALENDAR_DATES
	     WHERE  calendar_code = p_calendar
	       AND  calendar_date     = x_date;

Line: 100

			select	to_char(x_date,'DD-MM-YYYY')
			into	p_new_date
			from	dual;

Line: 142

	select	to_date(p_date,'DD-MM-YYYY')
	into	x_date
	from	dual;

Line: 160

	          SELECT  a.local_holiday_type, b.disable_date
                    INTO  x_type, x_disable_date
	            FROM  jl_br_local_holiday_dates a,
		          jl_br_local_holiday_sets b
                   WHERE  b.local_holiday_set_name = p_city  -- Bug 801019
                     AND  nvl(b.state,'$') = nvl(p_state,'$')  -- Bug 2319552
  	             AND  a.local_holiday_set_id   = b.local_holiday_set_id
  	             AND  a.local_holiday_date     = x_date
                     AND  nvl(b.disable_date,sysdate + 1) > sysdate;

Line: 195

	    SELECT  seq_num,	prior_date,	next_date
	      INTO  x_seq_num,      x_prior_date,   x_next_date
	      FROM  BOM_CALENDAR_DATES
	     WHERE  calendar_code = p_calendar
	       AND  calendar_date     = x_date;

Line: 212

			select	to_char(x_date,'DD-MM-YYYY')
			into	p_new_date
			from	dual;

Line: 265

        Select etb.town_or_city, etb.region_2
        From
               xle_establishment_v etb
              ,xle_bsv_associations bsv
              ,gl_ledger_le_v gl
        Where
              etb.legal_entity_id = gl.legal_entity_id
        And   bsv.legal_parent_id = etb.legal_entity_id
        And   etb.establishment_id = bsv.legal_construct_id
        And   bsv.entity_name = l_BSV
        And   gl.ledger_id = l_ledger_id;

Line: 279

        select set_of_books_id,substr(global_attribute4,1,25)
          into l_ledger_id,l_BSV
          from ap_system_parameters_all
          where  nvl(org_id,-99) = nvl(l_org_id,-99);