APPS.PAY_MLS_TRIGGERS SQL Statements

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

Line: 62

    select 1
      from pay_user_rows_f b
     where b.user_row_id = p_user_row_id
        and not exists
         -- this is the first insert ; there is no corresponding row in tl table

Line: 67

         ( select 1
              from pay_user_rows_f_tl tl
            where tl.user_row_id = p_user_row_id ) ;

Line: 87

    l_pur.delete;

Line: 93

     l_pur.delete;

Line: 102

   select 1
     from pay_user_rows_f_tl p
    where p.user_row_id = p_user_row_id
      and not exists
       ( select 1
           from pay_user_rows_f p1
          where p1.user_row_id = p_user_row_id

        );

Line: 123

    l_pur_del.delete;

Line: 128

     l_pur_del.delete;

Line: 180

    select 1
      from pay_balance_categories_f b
     where b.balance_category_id = p_balance_category_id
        and not exists
         -- this is the first insert ; there is no corresponding row in tl table

Line: 185

         ( select 1
              from pay_balance_categories_f_tl tl
            where tl.balance_category_id = p_balance_category_id ) ;

Line: 203

    l_pbc.delete;

Line: 208

     l_pbc.delete;

Line: 217

   select 1
     from pay_balance_categories_f_tl p
    where p.balance_category_id = p_balance_category_id
      and not exists
       ( select 1
           from pay_balance_categories_f p1
          where p1.balance_category_id = p_balance_category_id

        );

Line: 238

    l_pbc_del.delete;

Line: 243

     l_pbc_del.delete;

Line: 300

    select 1
      from ff_globals_f b
     where b.global_id = p_global_id
        and not exists
         -- this is the first insert; there is no corresponding row in tl table

Line: 305

         ( select 1
             from ff_globals_f_tl tl
            where tl.global_id = p_global_id ) ;

Line: 325

    l_glb.delete ;

Line: 330

     l_glb.delete;

Line: 339

   select 1
     from ff_globals_f_tl f
    where f.global_id = p_global_id
      and not exists
       ( select 1
           from ff_globals_f f1
          where f1.global_id = p_global_id

        );

Line: 365

    l_glb_del.delete;

Line: 371

     l_glb_del.delete;

Line: 427

   select 1
     from ff_formulas_f b
    where b.formula_id = p_formula_id
      and not exists
       -- this is the first insert ; there is no corresponding row in tl table

Line: 432

       ( select 1
           from ff_formulas_f_tl tl
          where tl.formula_id = p_formula_id ) ;

Line: 454

   l_fml.delete;

Line: 460

     l_fml.delete;

Line: 470

   select 1
     from ff_formulas_f_tl f
    where f.formula_id = p_formula_id
      and not exists
       ( select 1
           from ff_formulas_f f1
          where f1.formula_id = p_formula_id

        );

Line: 492

    l_fml_del.delete;

Line: 498

     l_fml_del.delete;