APPS.PAY_CA_RETRO_OVERLAP SQL Statements

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

Line: 31

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

Line: 40

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

Line: 49

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

Line: 75

   ltt_rule_type(1) := 'RETRO_DELETE';

Line: 129

                            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: 138

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