DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_PAGE_LAYOUTS

Line 245: from pa_page_layouts

241:
242: cursor get_page_name(c_page_id NUMBER)
243: IS
244: SELECT page_name
245: from pa_page_layouts
246: where page_id = c_page_id
247: and page_type_code = 'AI';
248: l_page_name pa_page_layouts.page_name%TYPE;
249:

Line 248: l_page_name pa_page_layouts.page_name%TYPE;

244: SELECT page_name
245: from pa_page_layouts
246: where page_id = c_page_id
247: and page_type_code = 'AI';
248: l_page_name pa_page_layouts.page_name%TYPE;
249:
250: CURSOR cur_projs
251: IS
252: SELECT carrying_out_organization_id

Line 1576: from pa_page_layouts

1572: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
1573: cursor get_page_name(c_page_id NUMBER)
1574: IS
1575: SELECT page_name
1576: from pa_page_layouts
1577: where page_id = c_page_id
1578: and page_type_code = 'AI';
1579:
1580: cursor get_current_page(c_object_id NUMBER)

Line 1589: l_page_name pa_page_layouts.page_name%TYPE;

1585: and object_type = 'PA_TASKS'
1586: and page_type_code = 'AI';
1587:
1588: l_opl_id NUMBER;
1589: l_page_name pa_page_layouts.page_name%TYPE;
1590: l_opl_rvn NUMBER;
1591:
1592: --hsiu
1593: --added for advanced structure - versioning