APPS.PA_DDC_PVT dependencies on DUAL

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

145: l_from_clause := 'pa_projects p,pa_project_accum_headers pah,pa_status_proj_bgt_rev_v r,pa_status_proj_bgt_cost_v c';
146:
147: -- WHERE_CLAUSE: -----------------------------------------
148:
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
150: AND pah.project_id = r.project_id AND pah.project_id = c.project_id';
151:
152: -- Append Basic From- and Where-Clauses as Required -------------------
153:

Line 787: FROM dual

783:
784: CURSOR check_csr
785: IS
786: SELECT 'Y'
787: FROM dual
788: WHERE EXISTS (select '1'
789: FROM pa_status_column_setup
790: WHERE folder_code = x_folder_code
791: AND INSTR(column_name,x_alias) > 0