APPS.PA_DDC_PVT SQL Statements

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

Line: 63

                SELECT format_code, column_name, currency_format_flag
                FROM
                pa_status_column_setup
                WHERE folder_code = 'P'
                order by folder_code, format_code, column_order;

Line: 70

                SELECT format_code, column_name, currency_format_flag
                FROM pa_status_column_setup
                WHERE folder_code = 'T'
                order by folder_code, format_code, column_order;

Line: 76

                SELECT format_code, column_name, currency_format_flag
                FROM pa_status_column_setup
                WHERE folder_code = 'R'
                order by folder_code, format_code, column_order;

Line: 137

)  as SELECT
        p.project_id
        , SUBSTR(pa_security.view_labor_costs(p.project_id),1,1)
        , c.budget_type_code
        , r.budget_type_code';

Line: 149

l_where_clause := '''Y'''||' in (SELECT pa_security.allow_query(p.project_id) from sys.dual) AND p.project_id = pah.project_id AND pah.task_id = 0 AND pah.resource_list_id = 0
 AND pah.project_id = r.project_id AND pah.project_id = c.project_id';

Line: 250

)  as SELECT
      t.project_id
        , t.task_id
        , t.parent_task_id
        , t.wbs_level
        , c.budget_type_code
        , r.budget_type_code
        , decode(pa_task_utils.check_child_exists(t.task_id),1,
         ''+'' ,0,'' '' )  ';

Line: 368

)  as SELECT
        pah.project_id
        , pah.resource_list_member_id
        , rlm1.parent_member_id
        , rlm1.member_level
        , rlm1.sort_order
        , pah.task_id
        , pah.resource_list_id
        , pah.resource_list_assignment_id
        , decode(pah.task_id, 0, ''Y'',''N'')
        , decode(pa_get_resource.child_resource_exists(pah.resource_list_member_id,
          pah.task_id,pah.project_id),
          ''Y'',''+'',''N'','' '')';

Line: 514

)  as SELECT
        p.project_id,
        p.projfunc_currency_code';

Line: 667

PROCEDURE Update_Ak_Item_Long_Label
(x_return_status		OUT	NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
, x_msg_count			OUT	NOCOPY NUMBER --File.Sql.39 bug 4440895
, x_msg_data			OUT	NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)

IS


l_api_name		CONSTANT VARCHAR2(30)	:= 'Update_Ak_Item_Long_Label';

Line: 685

       SELECT  column_prompt
       FROM    pa_status_column_setup
       WHERE folder_code = 'P'
       order by column_order;

Line: 700

      /* Commenting the call to Update_Item_Long_Label for bug 3684384
        OPEN  prompt_csr;

Line: 718

                AK_REGIONS_UTIL_PKG.Update_Item_Long_Label
                ( x_region_application_id	=> 275
                , x_region_code                 	=> 'PA_MY_PROJECTS_RESULT_LIST'
                , x_attribute_application_id    	=> 275
                , x_attribute_code              	=> l_attribute_code
                , x_attribute_label_long        	=> l_col_prompt_val
                , x_last_update_date            	=> sysdate
                , x_last_updated_by             	=> G_last_updated_by
                , x_last_update_login           	=> G_last_update_login
                );

Line: 754

END Update_Ak_Item_Long_Label;

Line: 786

        SELECT  'Y'
        FROM    dual
        WHERE EXISTS (select '1'
                      FROM    pa_status_column_setup
                      WHERE   folder_code = x_folder_code
                      AND     INSTR(column_name,x_alias) > 0
                      );