DBA Data[Home] [Help]

APPS.PJI_PAGE_LAYOUTS dependencies on PA_PROJECTS_ALL

Line 14: pa_projects_all proj,

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
18: AND play.PAGE_TYPE_CODE =p_page_type_code

Line 54: pa_projects_all proj,

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
58: AND play.PAGE_TYPE_CODE =p_page_type_code