DBA Data[Home] [Help]

APPS.PJI_PAGE_LAYOUTS dependencies on PA_PROJECT_TYPES_ALL

Line 15: pa_project_types_all ptype

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
19: AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE

Line 55: pa_project_types_all ptype

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
59: AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE