APPS.HR_DIRBAL SQL Statements

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

Line: 27

    SELECT
         fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
         paa.assignment_action_id),16))
    FROM pay_assignment_actions paa,
         pay_payroll_actions    ppa
    WHERE
         paa.assignment_id = p_assignment_id
    AND  ppa.payroll_action_id = paa.payroll_action_id
    AND  ppa.effective_date <= p_effective_date
    AND  ppa.action_type        in ('R', 'Q', 'I', 'V', 'B');

Line: 115

    select   ppa.time_period_id
     into     l_time_period_id
     from     pay_payroll_actions ppa,
              pay_assignment_actions paa
     where    paa.assignment_action_id = p_assignment_action_id
     and      ppa.payroll_action_id = paa.payroll_action_id;

Line: 122

    /* select   ptp.start_date,
              ptp.regular_payment_date
     into     l_period_start,
              l_period_end
     from     per_time_periods ptp
     where    ptp.time_period_id = p_period_id;*/

Line: 163

   select database_item_suffix
   from pay_balance_dimensions pbd,
        pay_defined_balances   pdb
   where pbd.balance_dimension_id = pdb.balance_dimension_id
   and   pdb.defined_balance_id = c_defined_balance_id;

Line: 250

   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, BACT.payroll_id
   from
        per_time_periods      PTP,
        pay_payroll_actions   BACT,
        pay_assignment_actions ACT
   where PTP.time_period_id = BACT.time_period_id
   and   ACT.assignment_action_id = c_assignment_action_id
   and   BACT.payroll_action_id = ACT.payroll_action_id;

Line: 268

   SELECT to_date('06-04-' || to_char( fnd_number.canonical_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) -
          mod(
           fnd_number.canonical_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),2)
            ),'DD-MM-YYYY') finyear, BACT.payroll_id
   FROM
         per_time_periods      PTP,
         pay_payroll_actions   BACT,
         pay_assignment_actions ACT
   WHERE PTP.time_period_id = BACT.time_period_id
   AND   ACT.assignment_action_id = c_assignment_action_id
   AND   BACT.payroll_action_id = ACT.payroll_action_id;

Line: 293

   SELECT to_date('06-04-' || to_char( fnd_number.canonical_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) -
          mod(
           fnd_number.canonical_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,0,-1),2)
            ),'DD-MM-YYYY') finyear, BACT.payroll_id
   FROM
         per_time_periods      PTP,
         pay_payroll_actions   BACT,
         pay_assignment_actions ACT
   WHERE PTP.time_period_id = BACT.time_period_id
   AND   ACT.assignment_action_id = c_assignment_action_id
   AND   BACT.payroll_action_id = ACT.payroll_action_id;

Line: 316

   select min(TP.start_date)
   from   per_time_periods TP
   where  TP.payroll_id = c_payroll_id
   and    TP.regular_payment_date  >= c_tax_yr_start;

Line: 404

    select ptp.end_date
    from per_time_periods ptp,
         pay_payroll_actions ppa,
         pay_assignment_actions paa
    WHERE
         paa.assignment_action_id = c_assignment_action_id
    AND  paa.payroll_action_id = ppa.payroll_action_id
    AND  ppa.time_period_id = ptp.time_period_id;

Line: 453

   SELECT    ppa.effective_date
   FROM      pay_payroll_actions ppa,
             pay_assignment_actions paa
   WHERE     paa.payroll_action_id = ppa.payroll_action_id
   AND       paa.assignment_action_id = p_assignment_action_id;