APPS.PAY_NZ_EXC SQL Statements

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

Line: 69

    SELECT ppa.business_group_id
      FROM pay_assignment_actions     paa
         , pay_payroll_actions        ppa
     WHERE paa.assignment_action_id = p_user_assignment_action_id
       AND ppa.payroll_action_id    = paa.payroll_action_id;

Line: 174

     select PTP.end_date
     from   per_time_periods ptp,
            pay_payroll_actions pact
     where  pact.payroll_action_id = p_payroll_action_id
     and    pact.payroll_id = ptp.payroll_id
     and    p_given_date between ptp.start_date and ptp.end_date;

Line: 294

   select fnd_date.canonical_to_date(org_information11)
   from   pay_payroll_actions PACT,
          hr_organization_information HOI
   where  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
   and    HOI.organization_id = PACT.business_group_id
   and    PACT.payroll_action_id = c_owner_payroll_action_id;

Line: 386

              SELECT ptp.start_date - 28
              FROM   per_time_periods       ptp
              WHERE ptp.payroll_id            = p_payroll_id
               AND p_effective_date    between ptp.start_date
                                             and ptp.end_date;

Line: 538

              SELECT ptp.start_date - 364
              FROM   per_time_periods       ptp
              WHERE ptp.payroll_id            = p_payroll_id
               AND p_effective_date    between ptp.start_date
                                             and ptp.end_date;