APPS.PA_IND_RATE_SCHEDULES_PKG SQL Statements

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

Line: 21

    select 1
    into   x_dummy
    from   sys.dual
    where  not exists
                    (select 1
                     from   pa_project_types_all pt
                     where  pt.cost_ind_rate_sch_id = x_ind_rate_sch_id
                     or     pt.rev_ind_rate_sch_id = x_ind_rate_sch_id
                     or     pt.inv_ind_rate_sch_id = x_ind_rate_sch_id
                     or     pt.cint_rate_sch_id = x_ind_rate_sch_id);/* added for  bug#3041364 */

Line: 46

    select 1
    into   x_dummy
    from   sys.dual
    where  not exists
                    (select 1
                     from   pa_projects_all p
                     where  p.cost_ind_rate_sch_id = x_ind_rate_sch_id
                     or     p.rev_ind_rate_sch_id = x_ind_rate_sch_id
                     or     p.inv_ind_rate_sch_id = x_ind_rate_sch_id
                     or     p.cint_rate_sch_id = x_ind_rate_sch_id); /* added for  bug#3041364 */

Line: 69

    select 1
    into   x_dummy
    from   sys.dual
    where  not exists
                    (select 1
                     from   pa_tasks t
                     where  t.cost_ind_rate_sch_id = x_ind_rate_sch_id
                     or     t.rev_ind_rate_sch_id = x_ind_rate_sch_id
                     or     t.inv_ind_rate_sch_id = x_ind_rate_sch_id);

Line: 92

    if (pa_fin_plan_utils.check_delete_burd_sch_ok(
                      p_ind_rate_sch_id => x_ind_rate_sch_id) = 'N') then
        x_return_status := 1;

Line: 105

    select 1
    into   x_dummy
    from   sys.dual
    where  exists (select 1
                   from   pa_alloc_txn_details p
		    	,pa_ind_rate_sch_revisions prev
                   where  p.ind_rate_sch_revision_id = prev.ind_rate_sch_revision_id
                   and    prev.ind_rate_sch_id = x_ind_rate_sch_id );

Line: 142

  select pov.profile_option_value
  into   x_ind_rate_schedule_type
  from   fnd_profile_option_values pov,
         fnd_profile_options po
  where  pov.application_id = po.application_id
  and    pov.profile_option_id = po.profile_option_id
  and    pov.level_id = 10001
  and    po.application_id = 275
  and    po.profile_option_name = 'PA_IND_RATE_SCHEDULE_TYPE'
  and    trunc(SYSDATE) between
	 trunc(po.start_date_active)
         and trunc(nvl(po.end_date_active, SYSDATE));

Line: 182

    select 1
    into   x_dummy
    from   sys.dual
    where  not exists
                    (select 1
                     from   pa_ind_rate_sch_revisions irsr
                     where  irsr.ind_rate_sch_id = x_ind_rate_sch_id);