DBA Data[Home] [Help]

APPS.PJI_PAGE_LAYOUTS dependencies on PA_PAGE_LAYOUTS

Line 13: FROM pa_page_layouts play,

9: l_page_id number ;
10:
11: CURSOR c_get_page_id is
12: SELECT page_id
13: FROM pa_page_layouts play,
14: pa_projects_all proj,
15: pa_project_types_all ptype
16: WHERE 1=1
17: AND proj.PROJECT_ID =p_project_id

Line 53: FROM pa_page_layouts play,

49: l_page_name varchar2(300);
50:
51: CURSOR c_get_page_name is
52: SELECT page_name
53: FROM pa_page_layouts play,
54: pa_projects_all proj,
55: pa_project_types_all ptype
56: WHERE 1=1
57: AND proj.PROJECT_ID =p_project_id