APPS.PA_CAPITAL_PROJECT_UTILS SQL Statements

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

Line: 25

     Select 1
     Into l_reversed
     From Dual
     where exists (
        SELECT 'X'
          FROM pa_project_asset_lines pal1
         WHERE pal1.project_asset_id = P_Asset_Id
           AND pal1.rev_proj_asset_line_id is null
           AND NOT EXISTS (select null from pa_project_asset_lines pal2
                            where pal2.project_asset_id = P_asset_id
                              and pal2.rev_proj_asset_line_id = pal1.project_asset_line_id));

Line: 69

     Select 1
       Into l_reversed
       From Dual
     where exists (
        SELECT 'X'
          FROM pa_project_asset_line_details pald
         WHERE pald.expenditure_item_id = P_Ei_Id
           AND  pald.reversed_flag = 'N');

Line: 108

   Select 1
   From Dual
   Where Exists (
     Select 1
     From Pa_Project_Assets
     Where Project_Id = P_Project_Id
     And Capital_Event_Id = P_Capital_Event_Id
     And (CAPITALIZED_FLAG = 'N' or
          (trunc(CAPITALIZED_DATE) < trunc(REVERSAL_DATE)
           or
           REVERSAL_DATE is not null )
          or (Fa_Asset_Id is not null and Is_Asset_Adj_Allowed(Fa_Asset_Id,Book_Type_Code) = 0)
         )
   ) ;

Line: 156

   Update Pa_Project_Assets
   Set    Reverse_Flag = 'Y'
   Where  Project_Id = P_Project_Id
   And    Reverse_Flag = 'N'
   And    Capital_Event_Id = P_Capital_Event_Id;

Line: 212

  select 'Y' from dual
  where exists (select tag_number
                   from fa_additions
                where tag_number = p_tag_number)
  or exists (select tag_number
             from pa_project_assets_all
             where tag_number = p_tag_number);

Line: 280

   Select 1
   From Dual
   Where Exists (select project_asset_id
                 from pa_project_asset_lines_all
                 where project_asset_id = P_Asset_Id);

Line: 354

    SELECT  1
    FROM    gl_code_combinations gcc,
            gl_sets_of_books gsob,
            pa_implementations pi
    WHERE   gcc.code_combination_id = l_deprn_expense_ccid
    AND     gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
    AND     gsob.set_of_books_id = pi.set_of_books_id
    AND     gcc.account_type = 'E';

Line: 416

FUNCTION Can_Delete_Event(P_Project_Id in NUMBER,
                          P_Capital_Event_Id in NUMBER) RETURN VARCHAR2 Is

    l_Exist Varchar2(1) := 'N';

Line: 422

    Select 'Y'
      From Dual
     Where Exists (Select 1 From Pa_Project_Assets_All
                    Where ProjecT_Id       = P_Project_Id
                      And Capital_Event_Id = P_Capital_Event_Id);

Line: 429

    Select 'Y'
      From Dual
     Where Exists (Select 1 From Pa_Expenditure_Items_All
                    Where ProjecT_Id       = P_Project_Id
                      And Capital_Event_Id = P_Capital_Event_Id);

Line: 456

End Can_Delete_Event;

Line: 485

                        G_CCID_Tab.Delete;

Line: 490

                SELECT  'Y'
                INTO    X_CCID_VALID
                FROM    gl_code_combinations gcc,
                        gl_sets_of_books gsob,
                        pa_implementations pi
                WHERE   gcc.code_combination_id = p_ccid
                AND     gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
                AND     gsob.set_of_books_id = pi.set_of_books_id
                AND     gcc.account_type = 'E';