APPS.PAY_US_ER_REARCH SQL Statements

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

Line: 72

              formated_data_string (p_input_string =>  'Updated Value'
                                   ,p_bold         => 'Y'
                                   ,p_output_file_type => p_output_file_type) ;

Line: 127

PROCEDURE insert_er_rearch_data(errbuf                OUT  nocopy  VARCHAR2,
                                retcode               OUT  nocopy   NUMBER,
                                p_year                IN      VARCHAR2,
                                p_tax_unit_id         IN      NUMBER,
                                p_fed_state           IN      VARCHAR2,
                                p_is_state            IN      VARCHAR2,
                                p_state_code          IN      VARCHAR2 default null)
IS

CURSOR c_yrend_pactid is
SELECT payroll_action_id
FROM   pay_payroll_actions
WHERE report_type = 'YREND'
AND action_status in ('E','C')
AND legislative_parameters like to_char(p_tax_unit_id)||'%'
AND to_char(effective_date,'YYYY') = substr(p_year,1,4);

Line: 146

SELECT NAME
FROM hr_organization_units
where organization_id = p_tax_unit_id;

Line: 156

   hr_utility.trace('PROCEDURE insert_er_rearch_data');

Line: 249

SELECT user_entity_name
FROM   ff_user_entities
WHERE user_entity_id = p_user_entity_id;

Line: 254

SELECT NAME
FROM hr_organization_units
where organization_id = to_number(c_tax_unit_id);

Line: 259

SELECT FULL_NAME
FROM   PER_PEOPLE_F
WHERE  person_id = to_number(c_person_id);

Line: 266

SELECT meaning
FROM fnd_common_lookups
WHERE lookup_type = c_lookup_type
AND lookup_code = c_lookup_code;

Line: 273

SELECT fips_code||' - ('||state_code||')'
FROM pay_state_rules
WHERe fips_code =  c_fips_code;