APPS.PA_DDC_API SQL Statements

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

Line: 9

	SELECT count(1)
	INTO	dummy
	FROM 	pa_status_column_setup
	WHERE	folder_code = x_folder_code
	AND	INSTR(column_name,x_alias) > 0;

Line: 41

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

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

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

)  as SELECT
	p.project_id
	, SUBSTR(pa_security.view_labor_costs(p.project_id),1,1)
	, c.budget_type_code
	, r.budget_type_code
	, 1
	, 2
	, 3
	, 4
	, 5
	, 6';

Line: 139

where_clause := '''Y''' ||' in (select pa_security.allow_query(pah.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: 228

)  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: 331

)  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'','' '')';