APPS.PQP_ITERATIVE_ARREARAGE SQL Statements

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

Line: 7

   select pbg.legislation_code
     from per_business_groups_perf pbg
    where pbg.business_group_id = c_business_grp_id;

Line: 13

   select hoi.org_information1
         ,hoi.org_information2
     from hr_organization_information  hoi
    where hoi.organization_id         = c_business_grp_id
      and hoi.org_information_context = c_org_information_context;

Line: 38

   select pei.eei_information1 -- Arrears Allowed
         ,pei.eei_information2 -- Partial Allowed
     from pay_element_types_f          pet,
          pay_element_type_extra_info  pei
    where pet.element_type_id    = c_ele_type_id
      and (pet.business_group_id = c_business_grp_id or
           pet.legislation_code  = l_legislation_code)
      and pei.element_type_id    = pet.element_type_id
      and pei.information_type   = c_information_type
      and trunc(c_effective_date) between pet.effective_start_date
                                      and pet.effective_end_date;

Line: 347

          ,p_inserted_flag        In Varchar2
          ,p_to_arrears           In Out NoCopy Number
          ,p_not_taken            In Out NoCopy Number
          ,p_arrears_taken        In Out NoCopy Number
          ,p_error_message        Out NoCopy Varchar2
          ,p_warning_message      Out NoCopy Varchar2
          ,p_remaining_amount     In Number   -- Optional Parameter
          ,p_guaranteed_net       In Number   -- Optional Parameter
          ,p_partial_allowed      In Varchar2 -- Optional Parameter
          ,p_arrears_allowed      In Varchar2 -- Optional Parameter
          ) Return Number Is

  l_dedn_amt             Number := 0;

Line: 397

        If p_inserted_flag ='N' Then
           l_actual_usercalc_amt := p_dedn_amt;

Line: 503

         ,p_inserted_flag        In Varchar2
         ,p_calc_method          In Varchar2
         ,p_to_within            In Number
         ,p_error_message        Out NoCopy Varchar2
         ,p_warning_message      Out NoCopy Varchar2
         ) Return Number Is

   l_return_value    Number := 0;

Line: 552

     g_Element_Values(p_ele_entryid).inserted_flag       := p_inserted_flag;

Line: 653

         ,p_inserted_flag       Out NoCopy Varchar2
         ,p_arrears_allowed     Out NoCopy Varchar2
         ,p_partial_allowed     Out NoCopy Varchar2
         ,p_calc_method         Out NoCopy Varchar2
         ,p_to_within           Out NoCopy Number
         ,p_error_message       Out NoCopy Varchar2
         ,p_warning_message     Out NoCopy Varchar2
         ) Return Number Is

 l_return_value Number        := 0;

Line: 678

     p_inserted_flag       := g_Element_Values(p_ele_entryid).inserted_flag;

Line: 717

     p_inserted_flag       := 'N';

Line: 756

 l_recs_deleted       Number := 0;

Line: 770

       g_Element_Values.DELETE(l_curr_ele_entry_id);

Line: 771

       l_recs_deleted      := l_recs_deleted + 1;

Line: 776

  p_warning_message := 'Records deleted from PL/SQL table :'||l_recs_deleted;