APPS.PAY_US_ITERATIVE_VALUES SQL Statements

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

Line: 362

        iter_val.DELETE(l_pos_no) ;

Line: 374

        iter_amt.DELETE(l_pos_no) ;

Line: 398

   assignment id, if yes then delete it else do nothing. */

     hr_utility.trace('In clear_on_asg ');

Line: 408

           iter_stop.DELETE ;

Line: 409

           iter_amt.DELETE ;

Line: 410

           iter_val.DELETE ;

Line: 411

           iter_ele_type.DELETE ;

Line: 412

           iter_ins.DELETE ;

Line: 540

            select  'Y'  into    v_arrears_flag
            from    pay_input_values_f ipv
            where   ipv.name  = 'Clear Arrears'
              and   p_date_earned  BETWEEN ipv.effective_start_date
                                       AND ipv.effective_end_date
              and   ipv.element_type_id  = p_eletype_id;

Line: 624

       select
             pet.element_name
             ,piv.name
             ,peev.screen_entry_value
       from pay_element_entries_f peef,
            pay_element_entry_values_f peev,
            pay_input_values_f piv,
            pay_element_links_f pel,
            pay_element_types_f pet,
            pay_element_classifications pec
       where peef.assignment_id = p_assignment_id
         and peef.creator_type <> 'UT'
         and p_date_earned between peef.effective_start_date
                               and peef.effective_end_date
         and peef.element_entry_id = peev.element_entry_id
         and p_date_earned between peev.effective_start_date
                               and peev.effective_end_date
         and peev.input_value_id = piv.input_value_id
         and piv.element_type_id = pet.element_type_id
         and piv.name = 'Jurisdiction'
         and p_date_earned between piv.effective_start_date
                               and piv.effective_end_date
         and peef.element_link_id = pel.element_link_id
         and p_date_earned between pel.effective_start_date
                               and pel.effective_end_date
         and pel.element_type_id = pet.element_type_id
         and p_date_earned between pet.effective_start_date
                               and pet.effective_end_date
         and pec.classification_id = pet.classification_id
         and pec.classification_name = 'Involuntary Deductions';

Line: 656

       select taxability_rules_date_id
       from   pay_taxability_rules_dates
       where  p_date_earned between valid_date_from and
                                    valid_date_to
       and    legislation_code = 'US';

Line: 669

       select 'Y'
       from   pay_taxability_rules
       where  jurisdiction_code        = p_juri_code
       and    tax_type                 = p_tax_type
       and    tax_category             = p_tax_cat
       and    classification_id        = p_classification_id
       and    taxability_rules_date_id = p_tax_rules_date_id
       and    legislation_code         = 'US'
       and    nvl(status,'VALID') <> 'D';

Line: 681

       select ps.state_code
       from   hr_locations             hrl
            , hr_soft_coding_keyflex   hrsckf
            , per_all_assignments_f    paf
            , pay_us_states            ps
       where p_date_earned BETWEEN paf.effective_start_date
                               and paf.effective_end_date
         and paf.assignment_id = p_assignment_id
         and paf.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id
         and nvl(hrsckf.segment18,paf.location_id) = hrl.location_id
         and ps.state_abbrev = nvl(hrl.loc_information17,hrl.region_2);

Line: 694

       select pet.element_information1, pet.classification_id
       from pay_element_types_f pet
       where pet.element_type_id = p_element_type_id
         and p_date_earned between pet.effective_start_date
                               and pet.effective_end_date;

Line: 797

       select pet.element_information2
       from   pay_element_types_f    pet
       where  pet.element_type_id = p_element_type_id
       and    p_date_earned BETWEEN pet.effective_start_date
                                AND pet.effective_end_date;

Line: 851

       hr_utility.trace('Inserting ');

Line: 897

FUNCTION set_inserted_flag (p_entry_id in  number,
                            p_asg_id   in  number,
                            p_ins_flag in  varchar2 )
RETURN VARCHAR2 IS

l_pos_no    number;

Line: 906

BEGIN /* set_inserted_flag */

     hr_utility.trace('In set_inserted_flag');

Line: 923

END; /* set_inserted_flag */

Line: 926

FUNCTION get_inserted_flag (p_entry_id in  number)
RETURN VARCHAR2 IS

l_found_flag   boolean;

Line: 934

BEGIN /* get_inserted_flag */

     hr_utility.trace('In get_inserted_flag');

Line: 950

END; /* get_inserted_flag */

Line: 1024

        iter_ins.DELETE;