3247: SELECT org_id FROM pa_implementations_all
3248: WHERE org_structure_version_id = l_version_id
3249: and start_organization_id = l_start_org_id;
3250:
3251: l_child_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3252: l_child_level_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3253: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3254:
3255: l_tmp_org_id pa_implementations_all.org_id%type;
3248: WHERE org_structure_version_id = l_version_id
3249: and start_organization_id = l_start_org_id;
3250:
3251: l_child_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3252: l_child_level_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3253: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3254:
3255: l_tmp_org_id pa_implementations_all.org_id%type;
3256: l_plsql_max_array_size CONSTANT NUMBER := 1000;
3249: and start_organization_id = l_start_org_id;
3250:
3251: l_child_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3252: l_child_level_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3253: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3254:
3255: l_tmp_org_id pa_implementations_all.org_id%type;
3256: l_plsql_max_array_size CONSTANT NUMBER := 1000;
3257: -- End for bug#5952671