APPS.PAYWSFGT_PKG SQL Statements

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

Line: 70

      SELECT  'Y'
      FROM    pay_functional_triggers
      WHERE   event_id = cp_id;

Line: 78

      SELECT  'Y'
      FROM    pay_functional_usages   pfu,
              pay_functional_areas    pfa,
              pay_functional_triggers pft
      WHERE   pfu.legislation_code   IN (cp_leg,'-1')
      AND     pfu.area_id          = pfa.area_id
      AND     pfa.area_id          = pft.area_id
      AND     pft.event_id         = cp_id;

Line: 91

      SELECT  'Y'
      FROM    pay_functional_usages   pfu,
              pay_functional_areas    pfa,
              pay_functional_triggers pft
      WHERE   pfu.business_group_id   IN (cp_bus,-1)
      AND     pfu.area_id           = pfa.area_id
      AND     pfa.area_id           = pft.area_id
      AND     pft.event_id          = cp_id;

Line: 104

      SELECT  'Y'
      FROM    pay_functional_usages   pfu,
              pay_functional_areas    pfa,
              pay_functional_triggers pft
      WHERE   pfu.payroll_id   IN (cp_pay,-1)
      AND     pfu.area_id    = pfa.area_id
      AND     pfa.area_id    = pft.area_id
      AND     pft.event_id   = cp_id;