APPS.PAY_GROUP_EVENT_PKG SQL Statements

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

Line: 139

  select '' chk
  from dual
  where exists (
  select pee.assignment_id
  from  ff_fdi_usages_f fdi
  ,     ff_globals_f glb
  ,     ff_formulas_f ff
  ,     PAY_STATUS_PROCESSING_RULES_F psp
  ,     PAY_FORMULA_RESULT_RULES_F pfr
  ,     pay_element_entries_f pee
  where glb.global_id = p_surrogate_key
  and   pee.assignment_id = p_assignment_id
  and   fdi.item_name = glb.global_name
  and   ff.formula_id = fdi.formula_id
  and   ((glb.legislation_code is null and glb.business_group_id is null) or
        (glb.legislation_code = ff.legislation_code) or
        (glb.business_group_id = ff.business_group_id) or
        (glb.legislation_code =
         (select bg.legislation_code
          from   per_business_groups_perf bg
          where bg.business_group_id = ff.business_group_id))
       )
  and   psp.formula_id = ff.formula_id
  and   pfr.STATUS_PROCESSING_RULE_ID = psp.STATUS_PROCESSING_RULE_ID
  );

Line: 185

select '' chk
from dual
where exists (
select pee.assignment_id
from  ff_fdi_usages_f fdi
,     ff_globals_f glb
,     ff_formulas_f ff
,     PAY_STATUS_PROCESSING_RULES_F psp
,     PAY_FORMULA_RESULT_RULES_F pfr
,     pay_element_entries_f pee
where glb.global_id = pay_interpreter_pkg.g_object_key
and   pee.element_entry_id = pay_interpreter_pkg.g_ee_id
and   pee.effective_end_date >= fdi.effective_start_date
and   pee.effective_start_date <= fdi.effective_end_date
and   fdi.item_name = glb.global_name
and   ff.formula_id = fdi.formula_id
and   ff.effective_start_date = fdi.effective_start_date
and   ff.effective_end_date = fdi.effective_end_date
and   ((glb.legislation_code is null and glb.business_group_id is null) or
      (glb.legislation_code = ff.legislation_code) or
      (glb.business_group_id = ff.business_group_id) or
      (glb.legislation_code =
       (select bg.legislation_code
        from   per_business_groups_perf bg
        where bg.business_group_id = ff.business_group_id))
     )
and   psp.formula_id = ff.formula_id
and   pee.effective_end_date >= psp.effective_start_date
and   pee.effective_start_date <= psp.effective_end_date
and   pfr.STATUS_PROCESSING_RULE_ID = psp.STATUS_PROCESSING_RULE_ID
and   pee.effective_end_date >= pfr.effective_start_date
and   pee.effective_start_date <= pfr.effective_end_date
);

Line: 260

  select '' chk
  from dual
  where exists (
  select pee.assignment_id
  from  ff_globals_f glb
  ,     pay_element_entries_f pee
  ,     pay_element_types_f pet
  where glb.global_id = p_surrogate_key
  and   pee.assignment_id = p_assignment_id
  and   glb.global_name in ('STANDARD_RATE','OVERTIME_RATE')
  and   pee.element_type_id = pet.element_type_id
  and   pet.element_name in ('Time Card','Overtime')
  );

Line: 294

select '' chk
from dual
where exists (
  select pee.assignment_id
  from  ff_globals_f glb
  ,     pay_element_entries_f pee
  ,     pay_element_types_f pet
  where glb.global_id = p_surrogate_key
  and   pee.assignment_id = p_assignment_id
  and   glb.global_name in ('STANDARD_RATE','OVERTIME_RATE')
  and   pee.element_type_id = pet.element_type_id
  and   pet.element_name in ('Time Card','Overtime')
  and   pee.effective_end_date >= pet.effective_start_date
  and   pee.effective_start_date <= pet.effective_end_date
);