APPS.PAY_CA_DD_MAGTAPE_PKG SQL Statements

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

Line: 24

select PMETH_INFORMATION2
from pay_org_payment_methods_f
where org_payment_method_id = cp_payment_method_id;

Line: 37

     select business_group_id,
            effective_date,
            to_char(overriding_dd_date,'YYMMDD'),
            org_payment_method_id,
            request_id,
            legislative_parameters
       into g_business_group_id,
            g_effective_date,
            g_direct_dep_date,
            g_org_payment_method_id,
            g_request_id,
            g_legislative_parameters
       from pay_payroll_actions
     where  payroll_action_id = g_payroll_action_id;

Line: 106

           select formula_name
           INTO l_ff_formula_name
             from FF_FORMULAS_F
            where g_effective_date between EFFECTIVE_START_DATE and
                                    EFFECTIVE_END_DATE
              and FORMULA_id     = l_ff_formula_id;

Line: 145

           select TO_CHAR(FORMULA_ID)
                  INTO p_ff_formula_id
             from FF_FORMULAS_F
            where g_effective_date between EFFECTIVE_START_DATE and
                                    EFFECTIVE_END_DATE
              and FORMULA_NAME     = p_formula_name;

Line: 262

           select formula_name
           INTO l_ff_formula_name
             from FF_FORMULAS_F
            where g_effective_date between EFFECTIVE_START_DATE and
                                    EFFECTIVE_END_DATE
              and FORMULA_id     = l_ff_formula_id;

Line: 281

           select TO_CHAR(FORMULA_ID)
                  INTO p_ff_formula_id
             from FF_FORMULAS_F
            where g_effective_date between EFFECTIVE_START_DATE and
                                    EFFECTIVE_END_DATE
              and FORMULA_NAME     = p_formula_name;