APPS.PAY_BF_EXPC SQL Statements

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

Line: 52

    *  Select the start of the current tax year.
    *  Follow this by comparing the tax year
    *  start with effective date of the run
    *  that created the balance.
    *  The dimension has expired if the owner
    *  date is less than the tax year start date,
    *  (i.e. we have passed a tax year boundary).
    */
/*
   select to_date('06-04-' || to_char( to_number(
          to_char( p_owner_effective_date,'YYYY'))
             +  decode(sign( p_user_effective_date - to_date('06-04-'
                 || to_char(p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
      -1,-1,0)),'DD-MM-YYYY')
   into l_tax_year_start
   from dual;

Line: 69

   Select to_date('06-04-' || to_char( to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear
   into l_tax_year_start
   from per_time_periods    PTP,
        pay_payroll_actions BACT
   where BACT.payroll_action_id = p_user_payroll_action_id
   and   PTP.time_period_id = BACT.time_period_id;

Line: 112

    *  Select the start of the current tax year.
    *  Follow this by comparing the tax year
    *  start with effective date of the run
    *  that created the balance.
    *  The dimension has expired if the owner
    *  date is less than the tax year start date,
    *  (i.e. we have passed a tax year boundary).
    */
/*
   select to_date('06-04-' || to_char( to_number(
          to_char( p_user_effective_date,'YYYY'))
             +  decode(sign( p_user_effective_date - to_date('06-04-'
                 || to_char(p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
      -1,-1,0)),'DD-MM-YYYY')
   into l_tax_year_start
   from dual;

Line: 130

   Select to_date('06-04-' || to_char( to_number(
          to_char( PTP.regular_payment_date,'YYYY'))
             +  decode(sign( PTP.regular_payment_date - to_date('06-04-'
                 || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
           -1,-1,0)),'DD-MM-YYYY') finyear
   into l_tax_year_start
   from per_time_periods    PTP,
        pay_payroll_actions BACT
   where BACT.payroll_action_id = p_user_payroll_action_id
   and   PTP.time_period_id = BACT.time_period_id;

Line: 172

   select TP.start_date
   into   l_period_start_date
   from   per_time_periods TP,
          pay_payroll_actions PACT
   where  PACT.payroll_action_id = p_user_payroll_action_id
   and    PACT.payroll_id = TP.payroll_id
   and    p_user_effective_date between TP.start_date and TP.end_date;

Line: 211

   select TP.start_date
   into   l_period_start_date
   from   per_time_periods TP,
          pay_payroll_actions PACT
   where  PACT.payroll_action_id = p_user_payroll_action_id
   and    PACT.payroll_id = TP.payroll_id
   and    p_user_effective_date between TP.start_date and TP.end_date;

Line: 253

   select TP.start_date
   into   l_period_start_date
   from   per_time_periods       TP,
          pay_assignment_actions ACT,
          pay_payroll_actions    PACT
   where  ACT.assignment_action_id = p_user_assignment_action_id
   and    ACT.payroll_action_id    = PACT.payroll_action_id
   and    PACT.payroll_id          = TP.payroll_id
   and    p_user_effective_date between TP.start_date and TP.end_date;

Line: 350

   select to_date('06-04-' || to_char( to_number(
          to_char( p_user_effective_date,'YYYY'))
             +  decode(sign( p_user_effective_date - to_date('06-04-'
                 || to_char(p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
      -1,-1,0)),'DD-MM-YYYY')
   into l_tax_year_start
   from dual;

Line: 386

   select nvl(ass_attribute1, 'CO')
   into   ni_status
   from   per_assignments_f
   where  assignment_id = p_assignment_id
   and    p_effective_date between
                effective_start_date and effective_end_date;