APPS.PA_MISC SQL Statements

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

Line: 13

      SELECT exp_cycle_start_day_code
      INTO   x_exp_cycle_start_day_code
      FROM   pa_implementations;

Line: 34

      SELECT set_of_books_id
      INTO   x_set_of_books_id
      FROM   pa_implementations;

Line: 65

        SELECT job_id
        INTO   x_job_id
        FROM   pa_job_assignment_overrides pjao
        WHERE  x_person_id = pjao.person_id
        AND    x_task_id   = pjao.task_id
        AND    x_effective_date BETWEEN pjao.start_date_active
			        AND pjao.end_date_active;

Line: 85

          SELECT job_id
          INTO   x_job_id
          FROM   pa_job_assignment_overrides pjao
          WHERE  x_person_id   = pjao.person_id
          AND    x_project_id  = pjao.project_id
          AND    x_effective_date BETWEEN pjao.start_date_active
			          AND pjao.end_date_active;

Line: 106

          SELECT job_id
          INTO   x_job_id
          FROM   pa_implementations imp,
                 per_assignments_f asn
          WHERE  x_person_id   = asn.person_id
          AND    asn.primary_flag = 'Y'
          AND    asn.business_group_id+0 = imp.business_group_id
          AND    x_effective_date BETWEEN asn.effective_start_date
			          AND asn.effective_end_date;

Line: 146

      SELECT pa_utils.GetWeekEnding(x_expenditure_item_date)
      INTO x_week_ending_date
      FROM SYS.DUAL;

Line: 169

      SELECT LAST_DAY(x_expenditure_item_date)
      INTO x_month_ending_date
      FROM SYS.DUAL;

Line: 191

      SELECT pp.period_name
      INTO x_pa_period
      FROM pa_periods pp
      WHERE x_pa_date between pp.start_date and pp.end_date;

Line: 216

      SELECT gps.period_name
      INTO x_gl_period
      FROM gl_period_statuses gps
      WHERE x_gl_date between gps.start_date and gps.end_date
      AND   gps.application_id+0 = 101
      AND   gps.adjustment_period_flag||'' <> 'Y'
      AND   gps.set_of_books_id = pa_misc.get_set_of_books_id;