APPS.PAY_US_RETRO_OVERLAP SQL Statements

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

Line: 50

     SELECT rule_mode
       FROM pay_legislation_rules
      WHERE legislation_code = cp_legislation_code
        AND rule_type = cp_rule_type;

Line: 59

     SELECT upgrade_definition_id
       FROM pay_upgrade_definitions
      WHERE legislation_code = cp_legislation_code
        AND short_name=cp_short_name;

Line: 68

     SELECT status
       FROM pay_upgrade_status
      WHERE legislation_code = cp_legislation_code
        AND upgrade_definition_id = cp_upgrade_defination_id;

Line: 79

       SELECT 'Y'
         FROM pay_payroll_actions ppa
        WHERE ppa.action_type = 'L'
          AND EXISTS ( SELECT 'Y'
                         FROM hr_organization_information hoi,
                              hr_all_organization_units   hou
                        WHERE hoi.org_information_context = 'Business Group Information'
                          AND hou.organization_id         = hoi.organization_id
                          AND hoi.org_information9 = UPPER(p_legislation_code)
                          AND hoi.organization_id = ppa.business_group_id
									   )
        AND ROWNUM < 2;            */

Line: 92

       SELECT 'Y'
        FROM pay_payroll_actions ppa
       WHERE ppa.action_type = 'L'
         AND EXISTS ( SELECT 'Y'
                        FROM hr_organization_information hoi
                       WHERE hoi.org_information_context = 'Business Group Information'
                         AND hoi.org_information9 = UPPER(p_legislation_code)
                         AND hoi.organization_id = ppa.business_group_id)
        AND ROWNUM < 2;*/

Line: 103

       SELECT business_group_id
         FROM per_business_groups pbg,
              hr_organization_information hoi
        WHERE hoi.organization_id = pbg.business_group_id
          AND hoi.org_information_context = 'Business Group Information'
          AND hoi.org_information9 = UPPER(p_legislation_code);

Line: 112

       SELECT 'Y'
         FROM pay_assignment_actions paa ,
              pay_retro_assignments pra,
              pay_payroll_actions ppa
        WHERE ppa.action_type = 'L'
          AND ppa.business_group_id = p_business_group_id
          AND paa.payroll_action_id = ppa.payroll_action_id
          AND pra.retro_assignment_action_id=paa.assignment_action_id
          AND ROWNUM < 2;

Line: 148

   ltt_rule_type(1) := 'RETRO_DELETE';

Line: 210

                            UPDATE  pay_legislation_rules
                            SET     RULE_MODE = ltt_rule_mode(3)
                            WHERE   legislation_code = lv_legislation_code
                            AND     rule_type =  ltt_rule_type(3);

Line: 219

                        INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
                        VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));

Line: 233

                    legislation rule can be inserted  */

                   IF(c_upgrade_status%FOUND) THEN
                     fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced RetroPay has Errored' );

Line: 269

                         SELECT count(1)
                         INTO l_retro_payroll_count
                         FROM pay_payroll_actions
                         WHERE business_group_id = lc.business_group_id
                         AND action_type = 'L';

Line: 313

                  UPDATE  pay_legislation_rules
                  SET     RULE_MODE = ltt_rule_mode(3)
                  WHERE   legislation_code = lv_legislation_code
                  AND     rule_type =  ltt_rule_type(3);

Line: 321

                INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
                VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));