eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_FS_UPD_PKG SQL Statements

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

Line: 6


PROCEDURE update_report_fs_rec (p_pest_state_code     IN VARCHAR2,
                                           p_pest_fs_code        IN VARCHAR2,
                                           p_pest_id             IN NUMBER,
                                           p_session_id          IN NUMBER,
                                           p_bug_number          IN NUMBER,
                                           p_new_fs_code         IN VARCHAR2 )

IS

BEGIN

   begin

        insert into pay_us_rpt_totals
                    (attribute1, value1, value2, state_code, attribute2,
                     attribute3, attribute4, business_group_id, session_id,
                     tax_unit_id)
		        select  ppf.full_name ,
                        paf.assignment_id ,
                        paf.person_id ,
                        taxrule.state_code ,
                        to_char(taxrule.effective_start_date, 'DD-MON-YYYY'),
                        to_char(taxrule.effective_end_date, 'DD-MON-YYYY'),
                        taxrule.filing_status_code ,
                        taxrule.business_group_id ,
                        p_session_id, p_bug_number
  			    from pay_us_emp_state_tax_rules_f taxrule,
       		  	     per_assignments_f paf,
       			     per_all_people_f ppf
 		        where taxrule.state_code = p_pest_state_code
   		        and   taxrule.filing_status_code = p_pest_fs_code
                and   emp_state_tax_rule_id = p_pest_id
    		    and   taxrule.assignment_id = paf.assignment_id
                and   taxrule.effective_start_date between
                                              paf.effective_start_date
                                          and paf.effective_end_date
                and   taxrule.business_group_id = paf.business_group_id
                and   paf.person_id             = ppf.person_id
                and   taxrule.effective_start_date between
                                              ppf.effective_start_date
                                          and ppf.effective_end_date

--                order by paf.assignment_id
                ;

Line: 57


   update pay_us_emp_state_tax_rules_f
   set    filing_status_code = p_new_fs_code
   where  state_code = p_pest_state_code
   and    filing_status_code =  p_pest_fs_code
   and    emp_state_tax_rule_id = p_pest_id;

Line: 63


END update_report_fs_rec;

Line: 65


PROCEDURE update_filing_status(
                          p_tax_rule_id_start IN NUMBER,
                          p_tax_rule_id_end   IN NUMBER )

IS
CURSOR filing_status_cur IS
select state_code, filing_status_code, emp_state_tax_rule_id
  from pay_us_emp_state_tax_rules_f
 where emp_state_tax_rule_id between
       p_tax_rule_id_start and p_tax_rule_id_end ;

Line: 86


hr_utility.trace('Entering pay_us_fs_upd_pkg.update_filing_status');

Line: 91


select userenv('sessionid')
  into l_session_id
  from dual;

Line: 101


hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',1);

Line: 110


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 120


/* removed updates of Arkansas and Calif as they are not valid updates */

/*          ELSIF filing_status_rec.state_code = '04' and
                filing_status_rec.filing_status_code = '03'
                THEN
                hr_utility.set_location('Arkansas',3);

Line: 127


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 144


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 161


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 179


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '05' ) ;

Line: 196


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 212


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 228


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 244


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 260


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 276


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 292


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 308


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 324


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' )  ;

Line: 341


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 357


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 373


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 389


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 405


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 421


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 440


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 457


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 473


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 489


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 506


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 522


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 540


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 560


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 577


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 593


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 609


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' )  ;

Line: 625


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' )  ;

Line: 641


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 657


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 673


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 689


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 705


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 721


                update_report_fs_rec (
                                            p_pest_state_code =>
                                              filing_status_rec.state_code,
                                            p_pest_fs_code         =>
                                              filing_status_rec.filing_status_code,
                                            p_pest_id             =>
                                              filing_status_rec.emp_state_tax_rule_id,
                                            p_session_id          => l_session_id,
                                            p_bug_number          => l_bug_no,
                                            p_new_fs_code         => '01' ) ;

Line: 735


hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',40);

Line: 740


hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',45);

Line: 748


hr_utility.set_location('pay_us_fs_upd_pkg.update_filing_status',50);

Line: 755


END update_filing_status ;