APPS.PA_LIFECYCLES_PVT dependencies on PA_PROJ_WORKPLAN_ATTR

Line 908: FROM pa_proj_workplan_attr

904:
905: CURSOR l_row_proj_workplan_attrs
906: IS
907: SELECT rowid,record_version_number
908: FROM pa_proj_workplan_attr
909: WHERE proj_element_id = P_lifecycle_id
910: AND project_id = c_project_id;
911:
912:

Line 1529: From pa_proj_workplan_attr

1525: IS
1526: Select 'Y'
1527: From dual
1528: Where exists(Select 'XYZ'
1529: From pa_proj_workplan_attr
1530: Where lifecycle_version_id = P_lifecycle_version_id);
1531: Begin
1532: IF(p_debug_mode = 'Y') THEN
1533: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: Inside check_delete_lifecycle_ok...');

Line 1763: where exists(select 'XYZ' from pa_proj_workplan_attr

1759: BEGIN
1760: SELECT 'Y'
1761: into l_workplan_used
1762: from SYS.DUAL
1763: where exists(select 'XYZ' from pa_proj_workplan_attr
1764: where lifecycle_version_id = l_element_version_id);
1765: exception
1766: when NO_DATA_FOUND then
1767: l_workplan_used := 'N';

Line 2513: from pa_proj_workplan_attr

2509: select FND_API.G_FALSE into l_delete_ok
2510: from sys.dual
2511: where exists(
2512: select 'xyz'
2513: from pa_proj_workplan_attr
2514: where lifecycle_version_id = l_parent_elem_ver_id
2515: and current_phase_version_id = l_child_elem_ver_id);
2516:
2517: exception