DBA Data[Home] [Help]

APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PA_PROJECTS_ALL

Line 1155: FROM pa_projects_all projects, hr_organization_units org

1151: ,p_organization OUT NOCOPY VARCHAR2) AS
1152: CURSOR c IS
1153: SELECT projects.name project_name
1154: ,org.name organization
1155: FROM pa_projects_all projects, hr_organization_units org
1156: WHERE projects.project_id = p_project_id
1157: AND projects.carrying_out_organization_id = org.organization_id;
1158: BEGIN
1159: FOR c_rec IN c

Line 1326: FROM pa_projects_all

1322: l_project_name VARCHAR2 (100);
1323: BEGIN
1324: SELECT name
1325: INTO l_project_name
1326: FROM pa_projects_all
1327: WHERE project_id = p_project_id;
1328: RETURN l_project_name;
1329: EXCEPTION
1330: WHEN OTHERS

Line 1597: FROM pa_projects_all

1593: l_project_name VARCHAR2 (100);
1594: BEGIN
1595: SELECT name
1596: INTO l_project_name
1597: FROM pa_projects_all
1598: WHERE project_id = p_project_id
1599: AND org_id = p_org_id;
1600:
1601: RETURN l_project_name;