DBA Data[Home] [Help]

APPS.PAY_CA_ISETUP_EARN_DEDN SQL Statements

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

Line: 36

   SELECT
     ff.formula_name,
     ft.formula_type_name
   FROM
     pay_status_processing_rules_f spr,
     ff_formulas_f ff,
     ff_formula_types ft
   WHERE
     spr.element_type_id = p_element_type_id AND
     spr.formula_id = ff.formula_id AND
     ff.formula_type_id = ft.formula_type_id;