DBA Data[Home] [Help]

APPS.PAY_SF_SHD SQL Statements

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

Line: 49

    select
    formula_id,
    template_type,
    legislation_code,
    business_group_id,
    formula_name,
    description,
    formula_text,
    formula_type_name,
    object_version_number
    from  pay_shadow_formulas
    where formula_id = p_formula_id;
Line: 128

    select formula_id,
           template_type,
           legislation_code,
           business_group_id,
           formula_name,
           description,
           formula_text,
           formula_type_name,
           object_version_number
    from   pay_shadow_formulas
    where   formula_id = p_formula_id
    for update nowait;