APPS.PAY_AU_EXC SQL Statements

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

Line: 52

     SELECT PTP.end_date+1
       INTO l_next_to_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: 195

	  select  ptp.time_period_id
	  from    pay_payroll_actions         act
	  ,       per_time_periods            ptp
	  where   payroll_action_id           = p_payroll_action_id
				 and act.date_earned         between ptp.start_date and ptp.end_date
				 and act.payroll_id          = ptp.payroll_id
				 and act.effective_date      = p_effective_date;

Line: 237

	  select  business_group_id
	  from    pay_assignment_actions_v
	  where   assignment_action_id = p_user_assignment_action_id;

Line: 369

        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;