DBA Data[Home] [Help]

APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on HR_ORGANIZATION_UNITS

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